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_US_MMREF_REPORTING dependencies on PAY_ASSIGNMENT_ACTIONS

Line 189: processor while the pay_assignment_actions looks for

185: --
186: --
187: /* Context and Parameter in the cursor are
188: Payroll_action_id table looks for value related to Year End pre-
189: processor while the pay_assignment_actions looks for
190: assignment actions of Mag. tapes
191: Context :
192: TAX_UNIT_ID - Submitter's Tax Unit ID
193: JURISDICTION_CODE - Set to Dummy Value as This is federal Cursor

Line 213: pay_assignment_actions AA

209: 'TAX_UNIT_NAME=P' , substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
210: 'TRANSFER_EMP_CODE=P', 'R'
211: FROM hr_all_organization_units hou,
212: pay_payroll_actions ppa,
213: pay_assignment_actions AA
214: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
215: ('TRANSFER_PAYROLL_ACTION_ID')
216: AND ppa.report_type = 'YREND'
217: AND to_char(ppa.effective_date,'YYYY')

Line 238: pay_assignment_actions AA

234: 'TAX_UNIT_NAME=P', substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
235: 'TRANSFER_EMP_CODE=P' , 'R'
236: FROM hr_all_organization_units hou,
237: pay_payroll_actions ppa,
238: pay_assignment_actions AA
239: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
240: ('TRANSFER_PAYROLL_ACTION_ID')
241: AND ppa.report_type = 'YREND'
242: AND to_char(ppa.effective_date,'YYYY')

Line 260: pay_assignment_actions AA

256: 'TAX_UNIT_NAME=P', substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
257: 'TRANSFER_EMP_CODE=P' , 'Q'
258: FROM hr_all_organization_units hou,
259: pay_payroll_actions ppa,
260: pay_assignment_actions AA
261: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
262: ('TRANSFER_PAYROLL_ACTION_ID')
263: AND ppa.report_type = 'YREND'
264: AND to_char(ppa.effective_date,'YYYY')

Line 293: pay_assignment_actions AA,

289: (PA.effective_date, AA.assignment_id)),
290: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
291: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
292: FROM pay_payroll_actions PA,
293: pay_assignment_actions AA,
294: pay_action_interlocks AI,
295: per_all_assignments_f SS,
296: per_all_people_f PE
297: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 328: pay_assignment_actions AA,

324: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
325: FROM per_all_people_f PE,
326: per_all_assignments_f SS,
327: pay_action_interlocks AI,
328: pay_assignment_actions AA,
329: pay_assignment_actions paa,
330: pay_payroll_actions PA,
331: ff_archive_items arch,
332: ff_user_entities fue

Line 329: pay_assignment_actions paa,

325: FROM per_all_people_f PE,
326: per_all_assignments_f SS,
327: pay_action_interlocks AI,
328: pay_assignment_actions AA,
329: pay_assignment_actions paa,
330: pay_payroll_actions PA,
331: ff_archive_items arch,
332: ff_user_entities fue
333: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 376: pay_assignment_actions AA,

372: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
373: FROM per_all_people_f PE,
374: per_all_assignments_f SS,
375: pay_action_interlocks AI,
376: pay_assignment_actions AA,
377: pay_payroll_actions PA
378: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
379: ('TRANSFER_PAYROLL_ACTION_ID')
380: AND AA.payroll_action_id = PA.payroll_action_id

Line 410: pay_assignment_actions paa

406: from ff_archive_items fai,
407: ff_contexts fc, -- JD
408: ff_database_items fdi,
409: ff_archive_item_contexts faic, -- JD
410: pay_assignment_actions paa
411: where paa.assignment_action_id
412: = pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID')
413: and paa.assignment_action_id = fai.context1
414: and fdi.user_name = 'A_COUNTY_WITHHELD_PER_JD_GRE_YTD'

Line 432: pay_assignment_actions paa

428: from ff_archive_items fai,
429: ff_contexts fc, -- JD
430: ff_database_items fdi,
431: ff_archive_item_contexts faic, -- JD
432: pay_assignment_actions paa
433: where paa.assignment_action_id =
434: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID')
435: and paa.assignment_action_id = fai.context1
436: and (fdi.user_name = 'A_SCHOOL_WITHHELD_PER_JD_GRE_YTD' OR