DBA Data[Home] [Help]

APPS.PAY_KW_PIFSS dependencies on PAY_CORE_UTILS

Line 39: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,

35: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
36: c_start_person_id in per_all_people_f.person_id%type,
37: c_end_person_id in per_all_people_f.person_id%type) is
38: select distinct a.assignment_id,
39: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
40: ppac.assignment_action_id
41: from per_assignments_f a,
42: per_people_f p,
43: pay_payroll_actions pa,

Line 52: and ppa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters)

48: and p.person_id = a.person_id
49: and p.business_group_id = pa.business_group_id
50: and ppa.payroll_action_id = ppac.payroll_action_id
51: and a.assignment_id = ppac.assignment_id
52: and ppa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters)
53: And ppa.action_type = 'X'
54: and ppa.action_status = 'C'
55: and ppac.assignment_action_id in
56: (select max(ppac1.assignment_action_id)