APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on PER_ALL_PEOPLE_F

Line 148: p_start_person_id in per_all_people_f.person_id%type,

144: -- archival has been done.
145:
146: procedure assignment_action_code
147: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
148: p_start_person_id in per_all_people_f.person_id%type,
149: p_end_person_id in per_all_people_f.person_id%type,
150: p_chunk in number) is
151:
152: v_next_action_id pay_assignment_actions.assignment_action_id%type;

Line 149: p_end_person_id in per_all_people_f.person_id%type,

145:
146: procedure assignment_action_code
147: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
148: p_start_person_id in per_all_people_f.person_id%type,
149: p_end_person_id in per_all_people_f.person_id%type,
150: p_chunk in number) is
151:
152: v_next_action_id pay_assignment_actions.assignment_action_id%type;
153:

Line 159: c_start_person_id in per_all_people_f.person_id%type,

155:
156:
157: cursor process_assignments
158: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
159: c_start_person_id in per_all_people_f.person_id%type,
160: c_end_person_id in per_all_people_f.person_id%type) is
161: select distinct a.assignment_id,
162: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
163: ppac.assignment_action_id

Line 160: c_end_person_id in per_all_people_f.person_id%type) is

156:
157: cursor process_assignments
158: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
159: c_start_person_id in per_all_people_f.person_id%type,
160: c_end_person_id in per_all_people_f.person_id%type) is
161: select distinct a.assignment_id,
162: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
163: ppac.assignment_action_id
164: from per_assignments_f a,

Line 281: ,c_start_person_id IN per_all_people_f.person_id%TYPE

277:
278:
279: CURSOR c_amend_process_assignments
280: (c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
281: ,c_start_person_id IN per_all_people_f.person_id%TYPE
282: ,c_end_person_id IN per_all_people_f.person_id%TYPE
283: ,c_archive_id IN pay_payroll_actions.payroll_action_id%TYPE
284: ,c_reg_emp IN pay_assignment_actions.tax_unit_id%TYPE
285: ,c_financial_year VARCHAR2)

Line 282: ,c_end_person_id IN per_all_people_f.person_id%TYPE

278:
279: CURSOR c_amend_process_assignments
280: (c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
281: ,c_start_person_id IN per_all_people_f.person_id%TYPE
282: ,c_end_person_id IN per_all_people_f.person_id%TYPE
283: ,c_archive_id IN pay_payroll_actions.payroll_action_id%TYPE
284: ,c_reg_emp IN pay_assignment_actions.tax_unit_id%TYPE
285: ,c_financial_year VARCHAR2)
286: IS