APPS.PAY_SG_IRAS_MAGTAPE dependencies on PAY_PAYROLL_ACTIONS

Line 13: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

9: -- Action.
10: -- Core Payroll recommend the SELECT has minimal restrictions.
11: ------------------------------------------------------------------------
12: procedure range_code
13: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
14: p_sql out nocopy varchar2) is
15: begin
16: hr_utility.set_location('Start of range_code',1);
17:

Line 20: 'pay_payroll_actions ppa ' ||

16: hr_utility.set_location('Start of range_code',1);
17:
18: p_sql := 'select distinct person_id ' ||
19: 'from per_people_f ppf, ' ||
20: 'pay_payroll_actions ppa ' ||
21: 'where ppa.payroll_action_id = :payroll_action_id ' ||
22: 'and ppa.business_group_id = ppf.business_group_id ' ||
23: 'order by ppf.person_id';
24:

Line 37: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

33: -- assignment action. This is done so that the archive can not be
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:

Line 50: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

46: select pay_assignment_actions_s.nextval
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,

Line 58: pay_payroll_actions pa

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 */
57: per_people_f p,
58: pay_payroll_actions pa
59: where pa.payroll_action_id = c_payroll_action_id
60: and p.person_id between c_start_person_id and c_end_person_id
61: and p.person_id = a.person_id
62: and p.business_group_id = pa.business_group_id

Line 66: pay_payroll_actions ppa,

62: and p.business_group_id = pa.business_group_id
63: and exists /* Bug No : 2242653 */
64: (select null
65: from
66: pay_payroll_actions ppa,
67: pay_assignment_actions pac
68: where ppa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters)
69: and ppa.action_type = 'X'
70: and ppa.action_status = 'C'

Line 81: pay_payroll_actions ppa1, -- payroll action id of the process that locks archive

77: from
78: pay_action_interlocks pai,
79: pay_assignment_actions paa1,--assignment action id of the action that locks archive
80: pay_assignment_actions paa2, -- assignment action id of the magtape
81: pay_payroll_actions ppa1, -- payroll action id of the process that locks archive
82: pay_payroll_actions ppa2 -- payroll action id of the magtape process
83: where pai.locked_action_id = paa1.assignment_action_id -- archive is locked
84: and pai.locking_action_id = paa2.assignment_action_id -- mgtape is looking the archive
85: and paa1.assignment_id = paa2.assignment_id

Line 82: pay_payroll_actions ppa2 -- payroll action id of the magtape process

78: pay_action_interlocks pai,
79: pay_assignment_actions paa1,--assignment action id of the action that locks archive
80: pay_assignment_actions paa2, -- assignment action id of the magtape
81: pay_payroll_actions ppa1, -- payroll action id of the process that locks archive
82: pay_payroll_actions ppa2 -- payroll action id of the magtape process
83: where pai.locked_action_id = paa1.assignment_action_id -- archive is locked
84: and pai.locking_action_id = paa2.assignment_action_id -- mgtape is looking the archive
85: and paa1.assignment_id = paa2.assignment_id
86: and paa1.assignment_id = a.assignment_id

Line 101: pay_payroll_actions ppa_arch

97: (
98: select
99: pay_core_utils.get_parameter('BASIS_YEAR', ppa_arch.legislative_parameters)
100: from
101: pay_payroll_actions ppa_arch
102: where
103: ppa_arch.payroll_action_id =
104: pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters)
105: ) /* Bug#4888368 */

Line 166: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

162: -- exist in pay_report_format_mappings_f, otherwise the archiver will
163: -- assume that no archival of data is required.
164: ------------------------------------------------------------------------
165: procedure initialization_code
166: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
167: begin
168: hr_utility.set_location('Start of initialization_code',6);
169: null;
170: hr_utility.set_location('End of initialization_code',7);