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 15: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

11: -- the archive process knows what code to execute for each step of
12: -- the archive.
13: --------------------------------------------------------------------
14: procedure range_code
15: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
16: p_sql out nocopy varchar2);
17:
18: procedure assignment_action_code
19: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

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

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

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

21: p_end_person_id in per_all_people_f.person_id%type,
22: p_chunk in number);
23:
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);

Line 52: from pay_payroll_actions mpa,

48: 'BASIS_YEAR=P',
49: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
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

Line 53: pay_payroll_actions apa,

49: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
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')

Line 76: from pay_payroll_actions mpa,

72: 'BASIS_YEAR=P',
73: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
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

Line 77: pay_payroll_actions apa,

73: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
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')

Line 100: from pay_payroll_actions mpa,

96: 'BASIS_YEAR=P',
97: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
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

Line 101: pay_payroll_actions apa,

97: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
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')

Line 124: from pay_payroll_actions mpa,

120: 'BASIS_YEAR=P',
121: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
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

Line 125: pay_payroll_actions apa,

121: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
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')

Line 166: pay_payroll_actions mpa,

162: paa.assignment_number assignment_number
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')

Line 168: pay_payroll_actions apa,

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

Line 203: pay_payroll_actions apa,

199: to_char(paa.person_id) person_id,
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,

Line 205: pay_payroll_actions mpa,

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,
209: ff_user_entities ffe,

Line 243: from pay_payroll_actions mpa,

239: 'ASS_EXTRA_ID=P',
240: ac3.context ass_extra_id,
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,

Line 244: pay_payroll_actions apa,

240: ac3.context ass_extra_id,
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,

Line 286: pay_payroll_actions mpa,

282: ac3.context person_extra_id, -- ac3.context ass_extra_id,
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,

Line 288: pay_payroll_actions apa,

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

Line 326: pay_payroll_actions mpa,

322: ac3.context person_extra_id, -- ac3.context ass_extra_id,
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,

Line 328: pay_payroll_actions apa,

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

Line 366: pay_payroll_actions mpa,

362: ac3.context person_extra_id, -- ac3.context ass_extra_id
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,

Line 368: pay_payroll_actions apa,

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

Line 406: pay_payroll_actions mpa,

402: ac3.context person_extra_id, -- ac3.context ass_extra_id
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,

Line 408: pay_payroll_actions apa,

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

Line 444: pay_payroll_actions mpa,

440: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', apa.legislative_parameters) tax_unit_id,
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,

Line 446: pay_payroll_actions apa,

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