APPS.PAY_SG_IRAS_MAGTAPE dependencies on PER_ALL_PEOPLE_F

Line 100: p_start_person_id in per_all_people_f.person_id%type,

96: -- rolled back without first rolling back the magtape.
97: ------------------------------------------------------------------------
98: procedure assignment_action_code
99: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
100: p_start_person_id in per_all_people_f.person_id%type,
101: p_end_person_id in per_all_people_f.person_id%type,
102: p_chunk in number) is
103:
104: v_next_action_id pay_assignment_actions.assignment_action_id%type;

Line 101: p_end_person_id in per_all_people_f.person_id%type,

97: ------------------------------------------------------------------------
98: procedure assignment_action_code
99: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
100: p_start_person_id in per_all_people_f.person_id%type,
101: p_end_person_id in per_all_people_f.person_id%type,
102: p_chunk in number) is
103:
104: v_next_action_id pay_assignment_actions.assignment_action_id%type;
105: v_archive_action_id pay_assignment_actions.assignment_action_id%type;

Line 114: c_start_person_id in per_all_people_f.person_id%type,

110: from dual;
111:
112: cursor process_assignments
113: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
114: c_start_person_id in per_all_people_f.person_id%type,
115: c_end_person_id in per_all_people_f.person_id%type,
116: c_type in ff_database_items.user_name%type) is
117: select distinct a.assignment_id,
118: pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters) archive_run_id,

Line 115: c_end_person_id in per_all_people_f.person_id%type,

111:
112: cursor process_assignments
113: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
114: c_start_person_id in per_all_people_f.person_id%type,
115: c_end_person_id in per_all_people_f.person_id%type,
116: c_type in ff_database_items.user_name%type) is
117: select distinct a.assignment_id,
118: pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters) archive_run_id,
119: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', pa.legislative_parameters) legal_entity_id