DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY_AMEND dependencies on PER_ALL_PEOPLE_F

Line 145: p_start_person_id IN per_all_people_f.person_id%TYPE,

141: */
142:
143: PROCEDURE assignment_action_code
144: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
145: p_start_person_id IN per_all_people_f.person_id%TYPE,
146: p_end_person_id IN per_all_people_f.person_id%TYPE,
147: p_chunk IN NUMBER)
148: IS
149:

Line 146: p_end_person_id IN per_all_people_f.person_id%TYPE,

142:
143: PROCEDURE assignment_action_code
144: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
145: p_start_person_id IN per_all_people_f.person_id%TYPE,
146: p_end_person_id IN per_all_people_f.person_id%TYPE,
147: p_chunk IN NUMBER)
148: IS
149:
150: v_next_action_id pay_assignment_actions.assignment_action_id%type;

Line 189: ,c_start_person_id IN per_all_people_f.person_id%TYPE

185: FROM pay_payroll_actions
186: WHERE payroll_action_id = c_payroll_Action_id;
187:
188: CURSOR process_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
189: ,c_start_person_id IN per_all_people_f.person_id%TYPE
190: ,c_end_person_id IN per_all_people_f.person_id%TYPE
191: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
192: ,c_financial_year IN VARCHAR2
193: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)

Line 190: ,c_end_person_id IN per_all_people_f.person_id%TYPE

186: WHERE payroll_action_id = c_payroll_Action_id;
187:
188: CURSOR process_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
189: ,c_start_person_id IN per_all_people_f.person_id%TYPE
190: ,c_end_person_id IN per_all_people_f.person_id%TYPE
191: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
192: ,c_financial_year IN VARCHAR2
193: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
194: IS

Line 235: ,c_start_person_id IN per_all_people_f.person_id%TYPE

231: );
232:
233:
234: CURSOR process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
235: ,c_start_person_id IN per_all_people_f.person_id%TYPE
236: ,c_end_person_id IN per_all_people_f.person_id%TYPE
237: ,c_assignment_set_id IN NUMBER
238: ,c_financial_year IN VARCHAR2
239: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)

Line 236: ,c_end_person_id IN per_all_people_f.person_id%TYPE

232:
233:
234: CURSOR process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
235: ,c_start_person_id IN per_all_people_f.person_id%TYPE
236: ,c_end_person_id IN per_all_people_f.person_id%TYPE
237: ,c_assignment_set_id IN NUMBER
238: ,c_financial_year IN VARCHAR2
239: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
240: IS

Line 1520: l_employee_type per_all_people_f.current_Employee_Flag%TYPE;

1516: l_registered_employer hr_organization_units.organization_id%TYPE;
1517: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
1518: l_year_start pay_payroll_Actions.effective_date%TYPE;
1519: l_year_end pay_payroll_actions.effective_date%TYPE;
1520: l_employee_type per_all_people_f.current_Employee_Flag%TYPE;
1521: l_lst_yr_term varchar2(10);
1522: l_fin_year VARCHAR2(20);
1523: l_archive_action_id pay_assignment_actions.assignment_action_id%TYPE;
1524: