ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3233869E053B46B63588994Y 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 PAY PYGBBIKAUDIT US PAY GB BIK Audit Application: Payroll Source: GB BIK Audit Report Short Name: PYGBBIKAUDIT DB package: BI Publisher :business_group_id :date_run :payroll_action_id :prl_id 1 10 :payroll_action_id LOV Oracle PAY_GB_BIK_CLASS_1ANIC Y select ppa.payroll_action_id id, substr(to_char(ppa.effective_date,'DD-MON-YYYY') || ' (' || to_char(ppa.payroll_action_id) || ')',1,35) value, null description from pay_payroll_actions ppa where ppa.report_type in ('GB_BIK_ARC_REP') and ppa.report_qualifier='GB' and ppa.action_status='C' and ppa.action_type='X' and ppa.business_group_id=fnd_global.per_business_group_id order by ppa.effective_date desc Y US Archive Request ID 2 20 :debugflag Char N US Debug Flag