PAY GB BIK Audit

Description
Categories: BI Publisher, Human Resources
Application: Payroll
Source: GB BIK Audit Report
Short Name: PYGBBIKAUDIT
DB package:
					  SELECT  pai.action_context_id
       ,paaf.assignment_number ASG_NUMBER
       ,papf.full_name NAME
       ,pai.action_information21 BENEFIT_NAME
       ,pai.action_information14 CE_PTD
       ,pai.action_information15 CE_YTD
       ,decode (pai.action_information_category
               ,'GB BIK CAR AND CAR FUEL'
               ,NULL
               ,'GB BIK VANS'
               ,NULL
               ,pai.action_information7) COST
       ,pai.action_information20 DESCRIPTION
       ,pai.action_information17 KIND_OF_VEHICLE
       ,decode (pai.action_information_category
               ,'GB BIK CAR AND CAR FUEL'
               ,NULL
               ,'GB BIK VANS'
               ,NULL
               ,pai.action_information8) AMOUNT_MADE_GOOD
       ,pai.action_information18 TAX_DED_PAYMENTS
       ,pai.action_information19 PASSENGER_PAYMENTS
       ,decode (pai.action_information_category
               ,'GB BIK CAR AND CAR FUEL'
               ,pai.action_information2
               ,NULL) CASH_EQU_CAR
       ,decode (pai.action_information_category
               ,'GB BIK CAR AND CAR FUEL'
               ,pai.action_information3
               ,NULL) CASH_EQU_FUEL
       ,decode (pai.action_information_category
               ,'GB BIK CAR AND CAR FUEL'
               ,pai.action_information16
               ,'GB BIK VANS'
               ,pai.action_information16
               ,NULL) REGISTRATION_NUMBER
				,decode (pai.action_information_category
               ,'GB BIK CAR AND CAR FUEL'
               ,pai.action_information23              
               ,NULL) CASH_FORGONE_CAR
			    ,decode (pai.action_information_category
               ,'GB BIK CAR AND CAR FUEL'
               ,pai.action_information24
               ,NULL) CASH_FORGONE_FUEL
,decode (pai.action_information_category
               ,'GB BIK VANS'
               ,pai.action_information23              
               ,NULL) CASH_FORGONE_VAN
			    ,decode (pai.action_information_category
               ,'GB BIK VANS'
               ,pai.action_information24
               ,NULL) CASH_FORGONE_VAN_FUEL
FROM    pay_action_information pai
       ,pay_assignment_actions paa
       ,per_all_assignments_f paaf
       ,per_all_people_f papf
WHERE   paa.payroll_action_id = :PAYROLL_ACTION_ID
AND     paaf.person_id = papf.person_id
AND     pai.action_context_id (+) = paa.assignment_action_id
AND     pai.action_context_type (+) = 'AAP'
AND     (
                pai.action_information_category  LIKE 'GB BIK%'
        OR      pai.action_information_category IN
                (
                SELECT  element_name
                FROM    pay_element_types_f pet
                       ,pqp_configuration_values pcv
                WHERE   pet.element_type_id = pcv.pcv_information1
                AND     pcv_information_category = 'PAY_GB_BIK_DETAILS'
                AND     pcv.business_group_id = :BUSINESS_GROUP_ID
                )
        )
AND     pai.assignment_id = paa.assignment_id
AND     paaf.assignment_id = paa.assignment_id
AND     :DATE_RUN BETWEEN paaf.effective_start_date
                                AND     paaf.effective_end_date
and :DATE_RUN between papf.effective_start_date and papf.effective_end_date 
AND     paa.action_status = 'C'
AND     paaf.payroll_id = :PRL_ID
ORDER BY  papf.full_name , paaf.assignment_number , pai.action_information21
Parameter Name SQL text Validation
Debug Flag
 
Archive Request ID
 
LOV Oracle