PAY GB BIK Class 1A NIC
Description
Categories: BI Publisher
Application: Payroll
Source: GB BIK Class 1A NIC Report
Short Name: PYGBBIKNIC
DB package:
Source: GB BIK Class 1A NIC Report
Short Name: PYGBBIKNIC
DB package:
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
SELECT paaf.assignment_number asg_number , pai.action_information21 benefit_name , papf.full_name name , pai.action_information14 ce_ptd , pai.action_information15 ce_ytd 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 pai.action_context_id (+) = paa.assignment_action_id AND paaf.person_id = papf.person_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 paaf.assignment_id = paa.assignment_id AND pai.action_information13 = 'Y' AND paaf.effective_start_date = ( SELECT max (paaf2.effective_start_date) FROM per_all_assignments_f paaf2 WHERE paaf2.person_id = paaf.person_id AND paaf2.effective_start_date < :DATE_RUN AND paaf2.ASSIGNMENT_TYPE='E' ) AND papf.effective_start_date = ( SELECT max (papf2.effective_start_date) FROM per_all_people_f papf2 WHERE papf2.person_id = papf.person_id AND papf2.effective_start_date < :DATE_RUN ) 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 |