APPS.PAY_KW_PIFSS dependencies on PER_ALL_PEOPLE_F

Line 30: p_start_person_id in per_all_people_f.person_id%type,

26: END range_cursor;
27: --
28: procedure assignment_action_code
29: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
30: p_start_person_id in per_all_people_f.person_id%type,
31: p_end_person_id in per_all_people_f.person_id%type,
32: p_chunk in number) is
33: v_next_action_id pay_assignment_actions.assignment_action_id%type;
34: cursor process_assignments

Line 31: p_end_person_id in per_all_people_f.person_id%type,

27: --
28: procedure assignment_action_code
29: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
30: p_start_person_id in per_all_people_f.person_id%type,
31: p_end_person_id in per_all_people_f.person_id%type,
32: p_chunk in number) is
33: v_next_action_id pay_assignment_actions.assignment_action_id%type;
34: cursor process_assignments
35: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

Line 36: c_start_person_id in per_all_people_f.person_id%type,

32: p_chunk in number) is
33: v_next_action_id pay_assignment_actions.assignment_action_id%type;
34: cursor process_assignments
35: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
36: c_start_person_id in per_all_people_f.person_id%type,
37: c_end_person_id in per_all_people_f.person_id%type) is
38: select distinct a.assignment_id,
39: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
40: ppac.assignment_action_id

Line 37: c_end_person_id in per_all_people_f.person_id%type) is

33: v_next_action_id pay_assignment_actions.assignment_action_id%type;
34: cursor process_assignments
35: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
36: c_start_person_id in per_all_people_f.person_id%type,
37: c_end_person_id in per_all_people_f.person_id%type) is
38: select distinct a.assignment_id,
39: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
40: ppac.assignment_action_id
41: from per_assignments_f a,