PAY GB BIK Class 1A NIC

Description
Categories: BI Publisher
Columns: Asg Number, Benefit Name, Name, Ce Ptd, Ce Ytd ...
Application: Payroll
Source: GB BIK Class 1A NIC Report
Short Name: PYGBBIKNIC
DB package:
					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 NameSQL textValidation
Archive Request ID
 
LOV Oracle
Debug Flag