APPS.PAY_GB_HIST_ARCH_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 16: from pay_payroll_actions

12:
13: cursor csr_parameter_info(p_pact_id number,
14: p_token char) is
15: select pay_core_utils.get_parameter(p_token,legislative_parameters)
16: from pay_payroll_actions
17: where payroll_action_id = p_pact_id;
18:
19: l_token_value varchar2(50) := null;
20:

Line 73: pay_payroll_actions ppa

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

Line 84: pay_payroll_actions ppa,

80: --
81: hr_utility.trace('Range Cursor using Payroll Restriction');
82: sqlstr := 'SELECT DISTINCT ppf.person_id
83: FROM per_all_people_f ppf,
84: pay_payroll_actions ppa,
85: per_all_assignments_f paaf
86: WHERE ppa.payroll_action_id = :payroll_action_id
87: AND ppf.business_group_id +0 = ppa.business_group_id
88: AND paaf.person_id = ppf.person_id

Line 127: pay_payroll_actions ppa,

123: select distinct paa.assignment_action_id,
124: paaf.assignment_id,
125: ppa.effective_date
126: from per_all_assignments_f paaf,
127: pay_payroll_actions ppa,
128: pay_assignment_actions paa,
129: pay_action_interlocks lck,
130: pay_payroll_actions ppa1,
131: pay_assignment_actions paa1

Line 130: pay_payroll_actions ppa1,

126: from per_all_assignments_f paaf,
127: pay_payroll_actions ppa,
128: pay_assignment_actions paa,
129: pay_action_interlocks lck,
130: pay_payroll_actions ppa1,
131: pay_assignment_actions paa1
132: where paa.SOURCE_ACTION_ID is null
133: and paaf.person_id between stperson
134: and endperson

Line 176: from pay_payroll_actions

172: get_parameters(pactid,'P_END_DATE',l_end_date);
173:
174: select business_group_id
175: into l_bg_id
176: from pay_payroll_actions
177: where payroll_action_id = pactid;
178:
179: hr_utility.set_location('l_payroll_id :' ||l_payroll_id ,10);
180: hr_utility.set_location('l_start_date :' ||l_start_date ,10);