eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_PAYMENT_SUMMARY_AMEND dependencies on PER_ALL_PEOPLE_F

Line 223: p_start_person_id IN per_all_people_f.person_id%TYPE,

219: */
220:
221: PROCEDURE assignment_action_code
222: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
223: p_start_person_id IN per_all_people_f.person_id%TYPE,
224: p_end_person_id IN per_all_people_f.person_id%TYPE,
225: p_chunk IN NUMBER)
226: IS
227:

Line 224: p_end_person_id IN per_all_people_f.person_id%TYPE,

220:
221: PROCEDURE assignment_action_code
222: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
223: p_start_person_id IN per_all_people_f.person_id%TYPE,
224: p_end_person_id IN per_all_people_f.person_id%TYPE,
225: p_chunk IN NUMBER)
226: IS
227:
228: v_next_action_id pay_assignment_actions.assignment_action_id%type;

Line 269: ,c_start_person_id IN per_all_people_f.person_id%TYPE

265: FROM pay_payroll_actions
266: WHERE payroll_action_id = c_payroll_Action_id;
267:
268: CURSOR process_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
269: ,c_start_person_id IN per_all_people_f.person_id%TYPE
270: ,c_end_person_id IN per_all_people_f.person_id%TYPE
271: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
272: ,c_financial_year IN VARCHAR2
273: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)

Line 270: ,c_end_person_id IN per_all_people_f.person_id%TYPE

266: WHERE payroll_action_id = c_payroll_Action_id;
267:
268: CURSOR process_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
269: ,c_start_person_id IN per_all_people_f.person_id%TYPE
270: ,c_end_person_id IN per_all_people_f.person_id%TYPE
271: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
272: ,c_financial_year IN VARCHAR2
273: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
274: IS

Line 315: ,c_start_person_id IN per_all_people_f.person_id%TYPE

311: );
312:
313: /* 14621185 - new cursor for multiple amended without checking the previous AU_PAY_SUMM_AMEND */
314: CURSOR multi_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
315: ,c_start_person_id IN per_all_people_f.person_id%TYPE
316: ,c_end_person_id IN per_all_people_f.person_id%TYPE
317: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
318: ,c_financial_year IN VARCHAR2
319: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)

Line 316: ,c_end_person_id IN per_all_people_f.person_id%TYPE

312:
313: /* 14621185 - new cursor for multiple amended without checking the previous AU_PAY_SUMM_AMEND */
314: CURSOR multi_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
315: ,c_start_person_id IN per_all_people_f.person_id%TYPE
316: ,c_end_person_id IN per_all_people_f.person_id%TYPE
317: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
318: ,c_financial_year IN VARCHAR2
319: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
320: IS

Line 346: ,c_start_person_id IN per_all_people_f.person_id%TYPE

342: )
343: ;
344:
345: CURSOR process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
346: ,c_start_person_id IN per_all_people_f.person_id%TYPE
347: ,c_end_person_id IN per_all_people_f.person_id%TYPE
348: ,c_assignment_set_id IN NUMBER
349: ,c_financial_year IN VARCHAR2
350: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)

Line 347: ,c_end_person_id IN per_all_people_f.person_id%TYPE

343: ;
344:
345: CURSOR process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
346: ,c_start_person_id IN per_all_people_f.person_id%TYPE
347: ,c_end_person_id IN per_all_people_f.person_id%TYPE
348: ,c_assignment_set_id IN NUMBER
349: ,c_financial_year IN VARCHAR2
350: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
351: IS

Line 395: ,c_start_person_id IN per_all_people_f.person_id%TYPE

391: );
392:
393: /* 14621185 - new cursor for multiple amended without checking the previous AU_PAY_SUMM_AMEND */
394: CURSOR multi_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
395: ,c_start_person_id IN per_all_people_f.person_id%TYPE
396: ,c_end_person_id IN per_all_people_f.person_id%TYPE
397: ,c_assignment_set_id IN NUMBER
398: ,c_financial_year IN VARCHAR2
399: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)

Line 396: ,c_end_person_id IN per_all_people_f.person_id%TYPE

392:
393: /* 14621185 - new cursor for multiple amended without checking the previous AU_PAY_SUMM_AMEND */
394: CURSOR multi_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
395: ,c_start_person_id IN per_all_people_f.person_id%TYPE
396: ,c_end_person_id IN per_all_people_f.person_id%TYPE
397: ,c_assignment_set_id IN NUMBER
398: ,c_financial_year IN VARCHAR2
399: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
400: IS

Line 2237: l_employee_type per_all_people_f.current_Employee_Flag%TYPE;

2233: l_registered_employer hr_organization_units.organization_id%TYPE;
2234: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
2235: l_year_start pay_payroll_Actions.effective_date%TYPE;
2236: l_year_end pay_payroll_actions.effective_date%TYPE;
2237: l_employee_type per_all_people_f.current_Employee_Flag%TYPE;
2238: l_lst_yr_term varchar2(10);
2239: l_fin_year VARCHAR2(20);
2240: l_archive_action_id pay_assignment_actions.assignment_action_id%TYPE;
2241: