PAY GB - DEA Payment Schedule Output

Description
Categories: BI Publisher, Human Resources
Application: Payroll
Source: GB - DEA Payment Schedule Output
Short Name: PYGBDEASOP
DB package:
	select 
		paaf.ASSIGNMENT_number ASSIGNMENT_NUMBER,
		asg.ACTION_INFORMATION2 NI_NUMBER,
		asg.ACTION_INFORMATION3 EMP_NAME,
		asg.ACTION_INFORMATION4 DEA_REF_NUMBER,
		to_number(asg.ACTION_INFORMATION5) DEA_DEDUCTION_PTD,
		to_number(asg.ACTION_INFORMATION6) DEA_DEDUCTION_ITD,
                                                asg.ACTION_INFORMATION10 REASON,
		hrl.DESCRIPTION ISSUING_AUTH
		From
		pay_payroll_actions ppa,
		pay_action_information asg,
		pay_assignment_actions paa,
		per_all_Assignments_f paaf,
		per_time_periods ptp,
		hr_lookups hrl
		where 
		ppa.payroll_action_id = :PAYROLL_ACTION_ID
		and paa.payroll_action_id = :PAYROLL_ACTION_ID
		and ptp.time_period_id = to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PERIOD_ID'))
		and asg.ACTION_CONTEXT_ID = paa.ASSIGNMENT_ACTION_ID
		and asg.ACTION_CONTEXT_TYPE = 'AAP'
		and asg.ACTION_INFORMATION_CATEGORY = 'GB DEA ASG DETAILS'
		and ptp.regular_payment_date between paaf.effective_start_date and paaf.effective_end_date
		and paaf.assignment_id = paa.assignment_id
		and asg.action_information12 =  :PERSON_ID
		and asg.action_information4 = :REF_NUMBER
		and hrl.LOOKUP_TYPE(+) = 'GB_DEA_ISSUING_AUTHORITY'
		and hrl.LOOKUP_CODE(+) = asg.ACTION_INFORMATION14
		order by paaf.ASSIGNMENT_number
Parameter Name SQL text Validation
payroll_action_id