APPS.PAY_IE_HIST_ARCH_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 19: from pay_payroll_actions

15:
16: cursor csr_parameter_info(p_pact_id number,
17: p_token char) is
18: select pay_core_utils.get_parameter(p_token,legislative_parameters)
19: from pay_payroll_actions
20: where payroll_action_id = p_pact_id;
21:
22: l_token_value varchar2(50) := null;
23: l_proc VARCHAR2(50) := g_package || 'get_parameters';

Line 72: pay_payroll_actions ppa

68: -- Use full cursor not restricting by payroll
69: hr_utility.trace('Range Cursor Not using Payroll Restriction');
70: sqlstr := 'SELECT DISTINCT person_id
71: FROM per_people_f ppf,
72: pay_payroll_actions ppa
73: WHERE ppa.payroll_action_id = :payroll_action_id
74: AND ppa.business_group_id +0= ppf.business_group_id
75: ORDER BY ppf.person_id';
76: else

Line 81: pay_payroll_actions ppa,

77: -- The Payroll ID was used as parameter, so restrict by this
78: hr_utility.trace('Range Cursor using Payroll Restriction');
79: sqlstr := 'SELECT DISTINCT ppf.person_id
80: FROM per_all_people_f ppf,
81: pay_payroll_actions ppa,
82: per_all_assignments_f paaf
83: WHERE ppa.payroll_action_id = :payroll_action_id
84: AND ppf.business_group_id +0 = ppa.business_group_id
85: AND paaf.person_id = ppf.person_id

Line 122: pay_payroll_actions ppa,

118: select distinct paa.assignment_action_id,
119: paaf.assignment_id,
120: ppa.effective_date
121: from per_all_assignments_f paaf,
122: pay_payroll_actions ppa,
123: pay_assignment_actions paa,
124: pay_action_interlocks lck,
125: pay_payroll_actions ppa1,
126: pay_assignment_actions paa1

Line 125: pay_payroll_actions ppa1,

121: from per_all_assignments_f paaf,
122: pay_payroll_actions ppa,
123: pay_assignment_actions paa,
124: pay_action_interlocks lck,
125: pay_payroll_actions ppa1,
126: pay_assignment_actions paa1
127: where paa.SOURCE_ACTION_ID is null
128: and paaf.person_id between stperson and endperson
129: and ppa.report_type = 'IEPS'

Line 172: from pay_payroll_actions

168: get_parameters(pactid,'P_END_DATE',l_end_date);
169:
170: select business_group_id
171: into l_bg_id
172: from pay_payroll_actions
173: where payroll_action_id = pactid;
174:
175: hr_utility.set_location('l_payroll_id :' ||l_payroll_id ,20);
176: hr_utility.set_location('l_start_date :' ||l_start_date ,20);