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: -- the archive process knows what code to execute for each step of
10: -- the archive.
11: --------------------------------------------------------------------
12: procedure range_code
13: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
14: p_sql out nocopy varchar2);
15:
16: procedure assignment_action_code
17: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

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

13: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
14: p_sql out nocopy varchar2);
15:
16: procedure assignment_action_code
17: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
18: p_start_person_id in per_all_people_f.person_id%type,
19: p_end_person_id in per_all_people_f.person_id%type,
20: p_chunk in number);
21:

Line 23: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);

19: p_end_person_id in per_all_people_f.person_id%type,
20: p_chunk in number);
21:
22: procedure initialization_code
23: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
24:
25: procedure archive_code
26: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
27: p_effective_date in date);

Line 50: from pay_payroll_actions mpa,

46: 'BASIS_YEAR=P',
47: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
48: 'CREATION_DATE=P',
49: to_char(sysdate,'YYYYMMDD') creation_date
50: from pay_payroll_actions mpa,
51: pay_payroll_actions apa,
52: pay_assignment_actions aac,
53: ff_archive_items ffi,
54: ff_database_items fdi

Line 51: pay_payroll_actions apa,

47: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
48: 'CREATION_DATE=P',
49: to_char(sysdate,'YYYYMMDD') creation_date
50: from pay_payroll_actions mpa,
51: pay_payroll_actions apa,
52: pay_assignment_actions aac,
53: ff_archive_items ffi,
54: ff_database_items fdi
55: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 74: from pay_payroll_actions mpa,

70: 'BASIS_YEAR=P',
71: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
72: 'CREATION_DATE=P',
73: to_char(sysdate,'YYYYMMDD') creation_date
74: from pay_payroll_actions mpa,
75: pay_payroll_actions apa,
76: pay_assignment_actions aac
77: ,ff_archive_items ffi
78: ,ff_database_items fdi

Line 75: pay_payroll_actions apa,

71: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
72: 'CREATION_DATE=P',
73: to_char(sysdate,'YYYYMMDD') creation_date
74: from pay_payroll_actions mpa,
75: pay_payroll_actions apa,
76: pay_assignment_actions aac
77: ,ff_archive_items ffi
78: ,ff_database_items fdi
79: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 98: from pay_payroll_actions mpa,

94: 'BASIS_YEAR=P',
95: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
96: 'CREATION_DATE=P',
97: to_char(sysdate,'YYYYMMDD') creation_date
98: from pay_payroll_actions mpa,
99: pay_payroll_actions apa,
100: pay_assignment_actions aac,
101: ff_archive_items ffi,
102: ff_database_items fdi

Line 99: pay_payroll_actions apa,

95: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
96: 'CREATION_DATE=P',
97: to_char(sysdate,'YYYYMMDD') creation_date
98: from pay_payroll_actions mpa,
99: pay_payroll_actions apa,
100: pay_assignment_actions aac,
101: ff_archive_items ffi,
102: ff_database_items fdi
103: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 122: from pay_payroll_actions mpa,

118: 'BASIS_YEAR=P',
119: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
120: 'CREATION_DATE=P',
121: to_char(sysdate,'YYYYMMDD') creation_date
122: from pay_payroll_actions mpa,
123: pay_payroll_actions apa,
124: pay_assignment_actions aac,
125: ff_archive_items ffi,
126: ff_database_items fdi

Line 123: pay_payroll_actions apa,

119: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
120: 'CREATION_DATE=P',
121: to_char(sysdate,'YYYYMMDD') creation_date
122: from pay_payroll_actions mpa,
123: pay_payroll_actions apa,
124: pay_assignment_actions aac,
125: ff_archive_items ffi,
126: ff_database_items fdi
127: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 164: pay_payroll_actions mpa,

160: paa.assignment_number assignment_number
161: -- 'RECORD_INDICATOR_FLAG=P',
162: -- pay_sg_iras_magtape.return_indicator_flag(paa.assignment_id ,mpa.report_type)
163: from per_all_assignments_f paa,
164: pay_payroll_actions mpa,
165: pay_assignment_actions mac,
166: pay_payroll_actions apa,
167: pay_assignment_actions aac
168: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 166: pay_payroll_actions apa,

162: -- pay_sg_iras_magtape.return_indicator_flag(paa.assignment_id ,mpa.report_type)
163: from per_all_assignments_f paa,
164: pay_payroll_actions mpa,
165: pay_assignment_actions mac,
166: pay_payroll_actions apa,
167: pay_assignment_actions aac
168: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
169: and mpa.payroll_action_id = mac.payroll_action_id
170: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 201: pay_payroll_actions apa,

197: to_char(paa.person_id) person_id,
198: 'DATE_ORDER=P',
199: fnd_date.canonical_to_date(ac3.context) date_order
200: from per_all_assignments_f paa,
201: pay_payroll_actions apa,
202: pay_assignment_actions aac,
203: pay_payroll_actions mpa,
204: ff_archive_items fai,
205: ff_archive_item_contexts ac2,

Line 203: pay_payroll_actions mpa,

199: fnd_date.canonical_to_date(ac3.context) date_order
200: from per_all_assignments_f paa,
201: pay_payroll_actions apa,
202: pay_assignment_actions aac,
203: pay_payroll_actions mpa,
204: ff_archive_items fai,
205: ff_archive_item_contexts ac2,
206: ff_archive_item_contexts ac3,
207: ff_user_entities ffe,

Line 241: from pay_payroll_actions mpa,

237: 'ASS_EXTRA_ID=P',
238: ac3.context ass_extra_id,
239: 'PERSON_ID=P',
240: paa.person_id
241: from pay_payroll_actions mpa,
242: pay_payroll_actions apa,
243: pay_assignment_actions aac,
244: per_all_assignments_f paa,
245: ff_archive_items fai,

Line 242: pay_payroll_actions apa,

238: ac3.context ass_extra_id,
239: 'PERSON_ID=P',
240: paa.person_id
241: from pay_payroll_actions mpa,
242: pay_payroll_actions apa,
243: pay_assignment_actions aac,
244: per_all_assignments_f paa,
245: ff_archive_items fai,
246: ff_archive_items fai1,

Line 285: pay_payroll_actions mpa,

281: 'PERSON_ID=P',
282: to_char(paa.person_id) person_id
283: from per_all_assignments_f paa,
284: per_people_extra_info ppei, --per_assignment_extra_info paei, /* Bug 2691877 */
285: pay_payroll_actions mpa,
286: pay_assignment_actions mac,
287: pay_payroll_actions apa,
288: pay_assignment_actions aac,
289: ff_archive_items fai,

Line 287: pay_payroll_actions apa,

283: from per_all_assignments_f paa,
284: per_people_extra_info ppei, --per_assignment_extra_info paei, /* Bug 2691877 */
285: pay_payroll_actions mpa,
286: pay_assignment_actions mac,
287: pay_payroll_actions apa,
288: pay_assignment_actions aac,
289: ff_archive_items fai,
290: ff_archive_item_contexts ac2,
291: ff_archive_item_contexts ac3

Line 329: pay_payroll_actions mpa,

325: 'PERSON_ID=P',
326: to_char(paa.person_id) person_id
327: from per_all_assignments_f paa,
328: per_people_extra_info ppei, -- per_assignment_extra_info paei, /* Bug 2691877 */
329: pay_payroll_actions mpa,
330: pay_assignment_actions mac,
331: pay_payroll_actions apa,
332: pay_assignment_actions aac,
333: ff_archive_items fai,

Line 331: pay_payroll_actions apa,

327: from per_all_assignments_f paa,
328: per_people_extra_info ppei, -- per_assignment_extra_info paei, /* Bug 2691877 */
329: pay_payroll_actions mpa,
330: pay_assignment_actions mac,
331: pay_payroll_actions apa,
332: pay_assignment_actions aac,
333: ff_archive_items fai,
334: ff_archive_item_contexts ac2,
335: ff_archive_item_contexts ac3

Line 373: pay_payroll_actions mpa,

369: 'PERSON_ID=P',
370: to_char(paa.person_id) person_id
371: from per_all_assignments_f paa,
372: per_people_extra_info ppei, -- per_assignment_extra_info paei, /* Bug 2691877 */
373: pay_payroll_actions mpa,
374: pay_assignment_actions mac,
375: pay_payroll_actions apa,
376: pay_assignment_actions aac,
377: ff_archive_items fai,

Line 375: pay_payroll_actions apa,

371: from per_all_assignments_f paa,
372: per_people_extra_info ppei, -- per_assignment_extra_info paei, /* Bug 2691877 */
373: pay_payroll_actions mpa,
374: pay_assignment_actions mac,
375: pay_payroll_actions apa,
376: pay_assignment_actions aac,
377: ff_archive_items fai,
378: ff_archive_item_contexts ac2,
379: ff_archive_item_contexts ac3

Line 413: pay_payroll_actions mpa,

409: 'PERSON_ID=P',
410: to_char(paa.person_id) person_id
411: from per_all_assignments_f paa,
412: per_people_extra_info ppei, -- per_assignment_extra_info paei, /* Bug 2691877 */
413: pay_payroll_actions mpa,
414: pay_assignment_actions mac,
415: pay_payroll_actions apa,
416: pay_assignment_actions aac,
417: ff_archive_items fai,

Line 415: pay_payroll_actions apa,

411: from per_all_assignments_f paa,
412: per_people_extra_info ppei, -- per_assignment_extra_info paei, /* Bug 2691877 */
413: pay_payroll_actions mpa,
414: pay_assignment_actions mac,
415: pay_payroll_actions apa,
416: pay_assignment_actions aac,
417: ff_archive_items fai,
418: ff_archive_item_contexts ac2,
419: ff_archive_item_contexts ac3