eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 59: FROM pay_payroll_actions

55: INSTR(legislative_parameters,' ',
56: INSTR(legislative_parameters,p_token))
57: - (INSTR(legislative_parameters,p_token)+LENGTH(p_token)))
58: ,business_group_id
59: FROM pay_payroll_actions
60: WHERE payroll_action_id = p_pact_id;
61:
62: l_token_value VARCHAR2(150);
63: l_bg_id NUMBER;

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

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

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

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

Line 122: pay_payroll_actions pa

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
120: from per_assignments_f a, /* Bug# 2920732 */
121: per_people_f p,
122: pay_payroll_actions pa
123: where pa.payroll_action_id = c_payroll_action_id
124: and p.person_id between c_start_person_id and c_end_person_id
125: and p.person_id = a.person_id
126: and p.business_group_id = pa.business_group_id

Line 130: pay_payroll_actions ppa,

126: and p.business_group_id = pa.business_group_id
127: and exists /* Bug No : 2242653 */
128: (select null
129: from
130: pay_payroll_actions ppa,
131: pay_assignment_actions pac
132: where ppa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters)
133: and ppa.action_type = 'X'
134: and ppa.action_status = 'C'

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

141: from
142: pay_action_interlocks pai,
143: pay_assignment_actions paa1,--assignment action id of the action that locks archive
144: pay_assignment_actions paa2, -- assignment action id of the magtape
145: pay_payroll_actions ppa1, -- payroll action id of the process that locks archive
146: pay_payroll_actions ppa2 -- payroll action id of the magtape process
147: where pai.locked_action_id = paa1.assignment_action_id -- archive is locked
148: and pai.locking_action_id = paa2.assignment_action_id -- mgtape is looking the archive
149: and paa1.assignment_id = paa2.assignment_id

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

142: pay_action_interlocks pai,
143: pay_assignment_actions paa1,--assignment action id of the action that locks archive
144: pay_assignment_actions paa2, -- assignment action id of the magtape
145: pay_payroll_actions ppa1, -- payroll action id of the process that locks archive
146: pay_payroll_actions ppa2 -- payroll action id of the magtape process
147: where pai.locked_action_id = paa1.assignment_action_id -- archive is locked
148: and pai.locking_action_id = paa2.assignment_action_id -- mgtape is looking the archive
149: and paa1.assignment_id = paa2.assignment_id
150: and paa1.assignment_id = a.assignment_id

Line 166: pay_payroll_actions ppa_arch

162: (
163: select
164: pay_core_utils.get_parameter('BASIS_YEAR', ppa_arch.legislative_parameters)
165: from
166: pay_payroll_actions ppa_arch
167: where
168: ppa_arch.payroll_action_id =
169: pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters)
170: ) /* Bug#4888368 */

Line 174: pay_payroll_Actions ppas,

170: ) /* Bug#4888368 */
171: ))
172: or (g_report_type='A' AND exists (select '' from
173: pay_assignment_actions aacs,
174: pay_payroll_Actions ppas,
175: ff_archive_items ffis,
176: ff_database_items fdis
177: where ffis.context1 = aacs.assignment_action_id
178: and a.assignment_id = aacs.assignment_id

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

247: -- exist in pay_report_format_mappings_f, otherwise the archiver will
248: -- assume that no archival of data is required.
249: ------------------------------------------------------------------------
250: procedure initialization_code
251: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
252: begin
253: hr_utility.set_location('Start of initialization_code',6);
254: get_parameters(p_payroll_action_id,'REP_TYPE',g_report_type);
255: get_parameters(p_payroll_action_id,'FILE',g_file);