APPS.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 20: l_parameter pay_payroll_actions.legislative_parameters%TYPE;

16: p_parameter_string IN VARCHAR2
17: ,p_token IN VARCHAR2
18: ) RETURN VARCHAR2 IS
19: --
20: l_parameter pay_payroll_actions.legislative_parameters%TYPE;
21: l_start_pos NUMBER;
22: l_delimiter VARCHAR2(1);
23: --
24: BEGIN

Line 62: FROM pay_payroll_actions

58: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'PAYROLL_ID')
59: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'ASG_SET_ID')
60: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'EMP_ID')
61: ,business_group_id
62: FROM pay_payroll_actions
63: WHERE payroll_action_id = c_payroll_action_id;
64: --
65: BEGIN
66: --

Line 188: ,pay_payroll_actions ppa

184: ELSE
185: --
186: sqlstr := 'SELECT distinct person_id
187: FROM per_people_f ppf
188: ,pay_payroll_actions ppa
189: WHERE ppa.payroll_action_id = :payroll_action_id
190: AND ppa.business_group_id = ppf.business_group_id
191: ORDER BY ppf.person_id';
192: --

Line 228: FROM pay_payroll_actions ppa

224: ,hou.name organization
225: ,paa.location_id location_id
226: ,paa.payroll_id payroll_id
227: ,paa.job_id job_id
228: FROM pay_payroll_actions ppa
229: ,per_all_assignments_f paa
230: ,per_all_people_f pap
231: ,per_periods_of_service ppf
232: ,hr_organization_information hoi