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 FF_ARCHIVE_ITEMS

Line 35: -- Bug 3232300: Added joins for table ff_archive_items and ff_database_items

31: -- p_report_type in varchar2 ) return varchar2 ;
32: ---------------------------------------------------------------------
33: -- PUBLIC cursors to retrieve data and pass it to IRAS formulae that
34: -- will write out header information for the 3 file types.
35: -- Bug 3232300: Added joins for table ff_archive_items and ff_database_items
36: -- so that it selects only that assignment action id against
37: -- which archived header information exist.
38:
39: ---------------------------------------------------------------------

Line 53: ff_archive_items ffi,

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

Line 77: ,ff_archive_items ffi

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

Line 101: ff_archive_items ffi,

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

Line 125: ff_archive_items ffi,

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

Line 204: ff_archive_items fai,

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,
208: ff_routes ffr

Line 245: ff_archive_items fai,

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,
248: ff_archive_item_contexts ac2,
249: ff_archive_item_contexts ac3

Line 246: ff_archive_items fai1,

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,
248: ff_archive_item_contexts ac2,
249: ff_archive_item_contexts ac3
250: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 289: ff_archive_items fai,

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')
293: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')

Line 333: ff_archive_items fai,

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')
337: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')

Line 377: ff_archive_items fai,

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')
381: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')

Line 417: ff_archive_items fai,

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')
421: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')