DBA Data[Home] [Help]

APPS.PAY_HK_IR56_REPORT dependencies on PER_ALL_PEOPLE_F

Line 27: -- 29 May 03 kaverma 115.7 Bug#2920731 Replaced per_all_assignments_f and per_all_people_f

23: -- parameter of the procedure 'range_code'
24: -- Included checkfile command too.
25: -- 19 Feb 03 apunekar 115.4 Bug#2810178 Removed no. of copies passed to fnd_request.set_print_options
26: -- 25 Feb 03 apunekar 115.6 Bug#2810178 Reverted fix
27: -- 29 May 03 kaverma 115.7 Bug#2920731 Replaced per_all_assignments_f and per_all_people_f
28: -- by secured views per_assignments_f and per_people_f resp from queries.
29: -----------------------------------------------------------------------------
30:
31: ------------------------------------------------------------------------

Line 65: p_start_person_id in per_all_people_f.person_id%type,

61: -- standard Re-try, Rollback payroll process.
62: ------------------------------------------------------------------------
63: procedure assignment_action_code
64: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
65: p_start_person_id in per_all_people_f.person_id%type,
66: p_end_person_id in per_all_people_f.person_id%type,
67: p_chunk in number) is
68:
69: v_next_action_id pay_assignment_actions.assignment_action_id%type;

Line 66: p_end_person_id in per_all_people_f.person_id%type,

62: ------------------------------------------------------------------------
63: procedure assignment_action_code
64: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
65: p_start_person_id in per_all_people_f.person_id%type,
66: p_end_person_id in per_all_people_f.person_id%type,
67: p_chunk in number) is
68:
69: v_next_action_id pay_assignment_actions.assignment_action_id%type;
70:

Line 117: c_start_person_id in per_all_people_f.person_id%type,

113: -- Cursor to process all assignments.
114: --
115: cursor process_assignments
116: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
117: c_start_person_id in per_all_people_f.person_id%type,
118: c_end_person_id in per_all_people_f.person_id%type) is
119: select distinct paaf.assignment_id,
120: paa.assignment_action_id,
121: pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters) archive_action_id,

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

114: --
115: cursor process_assignments
116: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
117: c_start_person_id in per_all_people_f.person_id%type,
118: c_end_person_id in per_all_people_f.person_id%type) is
119: select distinct paaf.assignment_id,
120: paa.assignment_action_id,
121: pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters) archive_action_id,
122: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters) legal_entity_id