APPS.PAY_SG_IRAS_ARCHIVE_SETUP dependencies on PER_ALL_PEOPLE_F

Line 46: , p_start_person_id in per_all_people_f.person_id%type

42: -- standard Re-try, Rollback payroll process.
43: ----------------------------------------------------------------------------
44: procedure assignment_action_code
45: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
46: , p_start_person_id in per_all_people_f.person_id%type
47: , p_end_person_id in per_all_people_f.person_id%type
48: , p_chunk in number )
49: is
50: v_next_action_id pay_assignment_actions.assignment_action_id%type;

Line 47: , p_end_person_id in per_all_people_f.person_id%type

43: ----------------------------------------------------------------------------
44: procedure assignment_action_code
45: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
46: , p_start_person_id in per_all_people_f.person_id%type
47: , p_end_person_id in per_all_people_f.person_id%type
48: , p_chunk in number )
49: is
50: v_next_action_id pay_assignment_actions.assignment_action_id%type;
51: v_effective_date date;

Line 88: c_start_person_id in per_all_people_f.person_id%type,

84: -- Filters Assignments to be processed.
85: ----------------------------------------------------------------------------
86: cursor process_assignments
87: ( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
88: c_start_person_id in per_all_people_f.person_id%type,
89: c_end_person_id in per_all_people_f.person_id%type )
90: is
91: select distinct a.assignment_id
92: from per_assignments_f a,

Line 89: c_end_person_id in per_all_people_f.person_id%type )

85: ----------------------------------------------------------------------------
86: cursor process_assignments
87: ( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
88: c_start_person_id in per_all_people_f.person_id%type,
89: c_end_person_id in per_all_people_f.person_id%type )
90: is
91: select distinct a.assignment_id
92: from per_assignments_f a,
93: pay_payroll_actions pa

Line 205: v_national_identifier per_all_people_f.national_identifier%type;

201: procedure archive_code
202: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
203: , p_effective_date in date )
204: is
205: v_national_identifier per_all_people_f.national_identifier%type;
206: v_start_date varchar2(50); /* Bug# 3910804 */
207: v_person_id per_all_people_f.person_id%type;
208: v_assignment_id per_all_assignments_f.assignment_id%type;
209: v_setup_action pay_assignment_actions.payroll_action_id%type;

Line 207: v_person_id per_all_people_f.person_id%type;

203: , p_effective_date in date )
204: is
205: v_national_identifier per_all_people_f.national_identifier%type;
206: v_start_date varchar2(50); /* Bug# 3910804 */
207: v_person_id per_all_people_f.person_id%type;
208: v_assignment_id per_all_assignments_f.assignment_id%type;
209: v_setup_action pay_assignment_actions.payroll_action_id%type;
210: ------------------------------------------------------------------------
211: -- Get Person Details