PAY GB BIK Audit

➜ Back to Library
Description
Categories: BI Publisher
Application: Payroll
Source: GB BIK Audit Report
Short Name: PYGBBIKAUDIT
DB package:
Run PAY GB BIK Audit and other Oracle EBS reports with Blitz Report™ on our demo environment
					  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
Archive Request ID 
 
 LOV Oracle
Debug Flag 
 
 Char
Download
Related Blitz Reports
PAY GB BIK Class 1A NIC PAY Payroll Reconciliation Detail PAY Employee Payroll History PAY Employee Run Results PAY Employee Run Results Report (CA) PAY Fringe Benefits RKD Employee Element History SSP ShPP Adoption Element Results SSP ShPP Birth Element Results
Blitz Report™

Blitz Report™ provides multiple benefits: