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_ASSIGNMENT_ACTIONS

Line 26: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

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);
28:
29: -- commented out for bug 5616519
30: -- function return_indicator_flag( p_assignment_id in number,

Line 52: pay_assignment_actions aac,

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')
56: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 76: pay_assignment_actions aac

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')
80: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 100: pay_assignment_actions aac,

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')
104: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 124: pay_assignment_actions aac,

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')
128: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 165: pay_assignment_actions mac,

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')
169: and mpa.payroll_action_id = mac.payroll_action_id

Line 167: pay_assignment_actions aac

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)
171: and apa.payroll_action_id = aac.payroll_action_id

Line 202: pay_assignment_actions aac,

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,
206: ff_archive_item_contexts ac3,

Line 243: pay_assignment_actions aac,

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,
247: ff_database_items fdi,

Line 286: pay_assignment_actions mac,

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,
290: ff_archive_item_contexts ac2,

Line 288: pay_assignment_actions aac,

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
292: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 330: pay_assignment_actions mac,

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,
334: ff_archive_item_contexts ac2,

Line 332: pay_assignment_actions aac,

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
336: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 374: pay_assignment_actions mac,

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,
378: ff_archive_item_contexts ac2,

Line 376: pay_assignment_actions aac,

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
380: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 414: pay_assignment_actions mac,

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,
418: ff_archive_item_contexts ac2,

Line 416: pay_assignment_actions aac,

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
420: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')