APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on PER_ALL_PEOPLE_F

Line 76: p_start_person_id in per_all_people_f.person_id%type,

72: -- archival has been done.
73:
74: procedure assignment_action_code
75: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
76: p_start_person_id in per_all_people_f.person_id%type,
77: p_end_person_id in per_all_people_f.person_id%type,
78: p_chunk in number) is
79:
80: v_next_action_id pay_assignment_actions.assignment_action_id%type;

Line 77: p_end_person_id in per_all_people_f.person_id%type,

73:
74: procedure assignment_action_code
75: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
76: p_start_person_id in per_all_people_f.person_id%type,
77: p_end_person_id in per_all_people_f.person_id%type,
78: p_chunk in number) is
79:
80: v_next_action_id pay_assignment_actions.assignment_action_id%type;
81:

Line 87: c_start_person_id in per_all_people_f.person_id%type,

83:
84:
85: cursor process_assignments
86: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
87: c_start_person_id in per_all_people_f.person_id%type,
88: c_end_person_id in per_all_people_f.person_id%type) is
89: select distinct a.assignment_id,
90: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
91: ppac.assignment_action_id

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

84:
85: cursor process_assignments
86: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
87: c_start_person_id in per_all_people_f.person_id%type,
88: c_end_person_id in per_all_people_f.person_id%type) is
89: select distinct a.assignment_id,
90: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
91: ppac.assignment_action_id
92: from per_assignments_f a,

Line 146: ,c_start_person_id IN per_all_people_f.person_id%TYPE

142:
143:
144: CURSOR c_amend_process_assignments
145: (c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
146: ,c_start_person_id IN per_all_people_f.person_id%TYPE
147: ,c_end_person_id IN per_all_people_f.person_id%TYPE
148: ,c_archive_id IN pay_payroll_actions.payroll_action_id%TYPE
149: ,c_reg_emp IN pay_assignment_actions.tax_unit_id%TYPE
150: ,c_financial_year VARCHAR2)

Line 147: ,c_end_person_id IN per_all_people_f.person_id%TYPE

143:
144: CURSOR c_amend_process_assignments
145: (c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
146: ,c_start_person_id IN per_all_people_f.person_id%TYPE
147: ,c_end_person_id IN per_all_people_f.person_id%TYPE
148: ,c_archive_id IN pay_payroll_actions.payroll_action_id%TYPE
149: ,c_reg_emp IN pay_assignment_actions.tax_unit_id%TYPE
150: ,c_financial_year VARCHAR2)
151: IS