DBA Data[Home] [Help]

APPS.PAY_SG_IRAS_AMEND_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 82: v_assignment_id per_all_assignments_f.assignment_id%type;

78: p_chunk in number )
79: is
80: v_next_action_id pay_assignment_actions.assignment_action_id%type;
81: v_setup_action_id pay_payroll_actions.payroll_action_id%type;
82: v_assignment_id per_all_assignments_f.assignment_id%type;
83: v_person_id per_all_people_f.person_id%type;
84: v_assignment_set_id hr_assignment_sets.assignment_set_id%type;
85: --
86: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

Line 281: v_assignment_id per_all_assignments_f.assignment_id%type;

277: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
278: p_effective_date in date )
279: is
280: v_person_id per_all_people_f.person_id%type;
281: v_assignment_id per_all_assignments_f.assignment_id%type;
282: v_national_identifier varchar2(50);
283: v_archive_date pay_payroll_actions.effective_date%type;
284: l_person_id per_all_people_f.person_id%type;
285: l_archived_person_id binary_integer;