APPS.PAY_SG_IRAS_AMEND_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 92: c_start_person_id in per_all_people_f.person_id%type,

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

Line 93: c_end_person_id in per_all_people_f.person_id%type )

89: ----------------------------------------------------------------------------
90: cursor process_assignments
91: ( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
92: c_start_person_id in per_all_people_f.person_id%type,
93: c_end_person_id in per_all_people_f.person_id%type )
94: is
95: select distinct a.assignment_id
96: from per_assignments_f a,
97: pay_payroll_actions pa

Line 214: v_national_identifier per_all_people_f.national_identifier%type;

210: procedure archive_code
211: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
212: , p_effective_date in date )
213: is
214: v_national_identifier per_all_people_f.national_identifier%type;
215: v_start_date varchar2(50); /* Bug# 3910804 */
216: v_person_id per_all_people_f.person_id%type;
217: v_assignment_id per_all_assignments_f.assignment_id%type;
218: v_setup_action pay_assignment_actions.payroll_action_id%type;

Line 216: v_person_id per_all_people_f.person_id%type;

212: , p_effective_date in date )
213: is
214: v_national_identifier per_all_people_f.national_identifier%type;
215: v_start_date varchar2(50); /* Bug# 3910804 */
216: v_person_id per_all_people_f.person_id%type;
217: v_assignment_id per_all_assignments_f.assignment_id%type;
218: v_setup_action pay_assignment_actions.payroll_action_id%type;
219: ------------------------------------------------------------------------
220: -- Get Person Details