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 28: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

24: procedure initialization_code
25: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
26:
27: procedure archive_code
28: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
29: p_effective_date in date);
30:
31: -- commented out for bug 5616519
32: -- function return_indicator_flag( p_assignment_id in number,

Line 54: pay_assignment_actions aac,

50: 'CREATION_DATE=P',
51: to_char(sysdate,'YYYYMMDD') creation_date
52: from pay_payroll_actions mpa,
53: pay_payroll_actions apa,
54: pay_assignment_actions aac,
55: ff_archive_items ffi,
56: ff_database_items fdi
57: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
58: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 78: pay_assignment_actions aac

74: 'CREATION_DATE=P',
75: to_char(sysdate,'YYYYMMDD') creation_date
76: from pay_payroll_actions mpa,
77: pay_payroll_actions apa,
78: pay_assignment_actions aac
79: ,ff_archive_items ffi
80: ,ff_database_items fdi
81: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
82: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 102: pay_assignment_actions aac,

98: 'CREATION_DATE=P',
99: to_char(sysdate,'YYYYMMDD') creation_date
100: from pay_payroll_actions mpa,
101: pay_payroll_actions apa,
102: pay_assignment_actions aac,
103: ff_archive_items ffi,
104: ff_database_items fdi
105: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
106: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 126: pay_assignment_actions aac,

122: 'CREATION_DATE=P',
123: to_char(sysdate,'YYYYMMDD') creation_date
124: from pay_payroll_actions mpa,
125: pay_payroll_actions apa,
126: pay_assignment_actions aac,
127: ff_archive_items ffi,
128: ff_database_items fdi
129: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
130: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)

Line 167: pay_assignment_actions mac,

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

Line 169: pay_assignment_actions aac

165: from per_all_assignments_f paa,
166: pay_payroll_actions mpa,
167: pay_assignment_actions mac,
168: pay_payroll_actions apa,
169: pay_assignment_actions aac
170: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
171: and mpa.payroll_action_id = mac.payroll_action_id
172: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
173: and apa.payroll_action_id = aac.payroll_action_id

Line 204: pay_assignment_actions aac,

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

Line 245: pay_assignment_actions aac,

241: 'PERSON_ID=P',
242: paa.person_id
243: from pay_payroll_actions mpa,
244: pay_payroll_actions apa,
245: pay_assignment_actions aac,
246: per_all_assignments_f paa,
247: ff_archive_items fai,
248: ff_archive_items fai1,
249: ff_database_items fdi,

Line 287: pay_assignment_actions mac,

283: 'PERSON_ID=P',
284: to_char(paa.person_id) person_id
285: from per_all_assignments_f paa,
286: pay_payroll_actions mpa,
287: pay_assignment_actions mac,
288: pay_payroll_actions apa,
289: pay_assignment_actions aac,
290: ff_archive_items fai,
291: ff_archive_item_contexts ac2,

Line 289: pay_assignment_actions aac,

285: from per_all_assignments_f paa,
286: pay_payroll_actions mpa,
287: pay_assignment_actions mac,
288: pay_payroll_actions apa,
289: pay_assignment_actions aac,
290: ff_archive_items fai,
291: ff_archive_item_contexts ac2,
292: ff_archive_item_contexts ac3
293: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 327: pay_assignment_actions mac,

323: 'PERSON_ID=P',
324: to_char(paa.person_id) person_id
325: from per_all_assignments_f paa,
326: pay_payroll_actions mpa,
327: pay_assignment_actions mac,
328: pay_payroll_actions apa,
329: pay_assignment_actions aac,
330: ff_archive_items fai,
331: ff_archive_item_contexts ac2,

Line 329: pay_assignment_actions aac,

325: from per_all_assignments_f paa,
326: pay_payroll_actions mpa,
327: pay_assignment_actions mac,
328: pay_payroll_actions apa,
329: pay_assignment_actions aac,
330: ff_archive_items fai,
331: ff_archive_item_contexts ac2,
332: ff_archive_item_contexts ac3
333: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 367: pay_assignment_actions mac,

363: 'PERSON_ID=P',
364: to_char(paa.person_id) person_id
365: from per_all_assignments_f paa,
366: pay_payroll_actions mpa,
367: pay_assignment_actions mac,
368: pay_payroll_actions apa,
369: pay_assignment_actions aac,
370: ff_archive_items fai,
371: ff_archive_item_contexts ac2,

Line 369: pay_assignment_actions aac,

365: from per_all_assignments_f paa,
366: pay_payroll_actions mpa,
367: pay_assignment_actions mac,
368: pay_payroll_actions apa,
369: pay_assignment_actions aac,
370: ff_archive_items fai,
371: ff_archive_item_contexts ac2,
372: ff_archive_item_contexts ac3
373: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 407: pay_assignment_actions mac,

403: 'PERSON_ID=P',
404: to_char(paa.person_id) person_id
405: from per_all_assignments_f paa,
406: pay_payroll_actions mpa,
407: pay_assignment_actions mac,
408: pay_payroll_actions apa,
409: pay_assignment_actions aac,
410: ff_archive_items fai,
411: ff_archive_item_contexts ac2,

Line 409: pay_assignment_actions aac,

405: from per_all_assignments_f paa,
406: pay_payroll_actions mpa,
407: pay_assignment_actions mac,
408: pay_payroll_actions apa,
409: pay_assignment_actions aac,
410: ff_archive_items fai,
411: ff_archive_item_contexts ac2,
412: ff_archive_item_contexts ac3
413: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 445: pay_assignment_actions mac,

441: 'PERSON_ID=P',
442: to_char(paa.person_id) person_id
443: from per_all_assignments_f paa,
444: pay_payroll_actions mpa,
445: pay_assignment_actions mac,
446: pay_payroll_actions apa,
447: pay_assignment_actions aac,
448: ff_archive_items fai,
449: ff_archive_item_contexts ac2,

Line 447: pay_assignment_actions aac,

443: from per_all_assignments_f paa,
444: pay_payroll_actions mpa,
445: pay_assignment_actions mac,
446: pay_payroll_actions apa,
447: pay_assignment_actions aac,
448: ff_archive_items fai,
449: ff_archive_item_contexts ac2,
450: ff_archive_item_contexts ac3
451: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')