DBA Data[Home] [Help]

APPS.PAY_KR_SEP_ARCHIVE_PKG dependencies on PAY_KR_FF_FUNCTIONS_PKG

Line 14: and paa.payroll_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(bppa.payroll_action_id, ''PAYROLL_ID'', null))

10: from pay_payroll_actions bppa,
11: per_assignments_f paa
12: where bppa.payroll_action_id = :payroll_action_id
13: and paa.business_group_id = bppa.business_group_id
14: and paa.payroll_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(bppa.payroll_action_id, ''PAYROLL_ID'', null))
15: order by 1';
16: -- declared for archiving details related to efile
17:
18: TYPE t_arch_rec IS RECORD(item varchar2(50)

Line 707: and pa.payroll_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(bppa.payroll_action_id, 'PAYROLL_ID', null))

703: and pa.person_id
704: between p_start_person_id and p_end_person_id
705: and bppa.effective_date
706: between pa.effective_start_date and pa.effective_end_date
707: and pa.payroll_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(bppa.payroll_action_id, 'PAYROLL_ID', null))
708: and paa.assignment_id = pa.assignment_id
709: and paa.action_status = 'C'
710: and ppa.payroll_action_id = paa.payroll_action_id
711: and ppa.effective_date