DBA Data[Home] [Help]

APPS.PAY_SG_IRAS_MAGTAPE dependencies on PER_ALL_PEOPLE_F

Line 38: p_start_person_id in per_all_people_f.person_id%type,

34: -- rolled back without first rolling back the magtape.
35: ------------------------------------------------------------------------
36: procedure assignment_action_code
37: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
38: p_start_person_id in per_all_people_f.person_id%type,
39: p_end_person_id in per_all_people_f.person_id%type,
40: p_chunk in number) is
41:
42: v_next_action_id pay_assignment_actions.assignment_action_id%type;

Line 39: p_end_person_id in per_all_people_f.person_id%type,

35: ------------------------------------------------------------------------
36: procedure assignment_action_code
37: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
38: p_start_person_id in per_all_people_f.person_id%type,
39: p_end_person_id in per_all_people_f.person_id%type,
40: p_chunk in number) is
41:
42: v_next_action_id pay_assignment_actions.assignment_action_id%type;
43: v_archive_action_id pay_assignment_actions.assignment_action_id%type;

Line 51: c_start_person_id in per_all_people_f.person_id%type,

47: from dual;
48:
49: cursor process_assignments
50: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
51: c_start_person_id in per_all_people_f.person_id%type,
52: c_end_person_id in per_all_people_f.person_id%type) is
53: select distinct a.assignment_id,
54: pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters) archive_run_id,
55: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', pa.legislative_parameters) legal_entity_id

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

48:
49: cursor process_assignments
50: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
51: c_start_person_id in per_all_people_f.person_id%type,
52: c_end_person_id in per_all_people_f.person_id%type) is
53: select distinct a.assignment_id,
54: pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters) archive_run_id,
55: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', pa.legislative_parameters) legal_entity_id
56: from per_assignments_f a, /* Bug# 2920732 */