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

Line 133: processor while the pay_assignment_actions looks for

129: --
130: --
131: /* Context and Parameter in the cursor are
132: Payroll_action_id table looks for value related to Year End pre-
133: processor while the pay_assignment_actions looks for
134: assignment actions of Mag. tapes
135: Context :
136: TAX_UNIT_ID - Submitter's Tax Unit ID
137: JURISDICTION_CODE - Set to Dummy Value as This is federal Cursor

Line 157: pay_assignment_actions AA

153: 'TAX_UNIT_NAME=P' , substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
154: 'TRANSFER_EMP_CODE=P', 'R'
155: FROM hr_all_organization_units hou,
156: pay_payroll_actions ppa,
157: pay_assignment_actions AA
158: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
159: ('TRANSFER_PAYROLL_ACTION_ID')
160: AND ppa.report_type = 'YREND'
161: AND to_char(ppa.effective_date,'YYYY')

Line 181: pay_assignment_actions AA

177: 'TRANSFER_EMP_CODE=P', 'R',
178: 'TRANSFER_TAX_UNIT_ID=P', AA.tax_unit_id
179: FROM hr_all_organization_units hou,
180: pay_payroll_actions ppa,
181: pay_assignment_actions AA
182: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
183: ('TRANSFER_PAYROLL_ACTION_ID')
184: AND ppa.report_type = 'YREND'
185: AND to_char(ppa.effective_date,'YYYY')

Line 206: pay_assignment_actions AA

202: 'TAX_UNIT_NAME=P', substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
203: 'TRANSFER_EMP_CODE=P' , 'R'
204: FROM hr_all_organization_units hou,
205: pay_payroll_actions ppa,
206: pay_assignment_actions AA
207: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
208: ('TRANSFER_PAYROLL_ACTION_ID')
209: AND ppa.report_type = 'YREND'
210: AND to_char(ppa.effective_date,'YYYY')

Line 228: pay_assignment_actions AA

224: 'TAX_UNIT_NAME=P', substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
225: 'TRANSFER_EMP_CODE=P' , 'Q'
226: FROM hr_all_organization_units hou,
227: pay_payroll_actions ppa,
228: pay_assignment_actions AA
229: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
230: ('TRANSFER_PAYROLL_ACTION_ID')
231: AND ppa.report_type = 'YREND'
232: AND to_char(ppa.effective_date,'YYYY')

Line 258: FROM pay_assignment_actions paa

254: 'TRANSFER_ACT_ID')
255: FROM DUAL;
256: */
257: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
258: FROM pay_assignment_actions paa
259: WHERE paa.payroll_action_id =
260: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
261: AND paa.tax_unit_id =
262: pay_magtape_generic.get_parameter_value('TRANSFER_TAX_UNIT_ID');

Line 276: pay_assignment_actions AA,

272: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
273: FROM per_all_people_f PE,
274: per_all_assignments_f SS,
275: pay_action_interlocks AI,
276: pay_assignment_actions AA,
277: pay_payroll_actions PA
278: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
279: ('TRANSFER_PAYROLL_ACTION_ID')
280: AND AA.payroll_action_id = PA.payroll_action_id

Line 308: pay_assignment_actions AA,

304: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
305: FROM per_all_people_f PE,
306: per_all_assignments_f SS,
307: pay_action_interlocks AI,
308: pay_assignment_actions AA,
309: pay_assignment_actions paa,
310: pay_payroll_actions PA,
311: ff_archive_items arch,
312: ff_user_entities fue

Line 309: pay_assignment_actions paa,

305: FROM per_all_people_f PE,
306: per_all_assignments_f SS,
307: pay_action_interlocks AI,
308: pay_assignment_actions AA,
309: pay_assignment_actions paa,
310: pay_payroll_actions PA,
311: ff_archive_items arch,
312: ff_user_entities fue
313: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 356: pay_assignment_actions AA,

352: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
353: FROM per_all_people_f PE,
354: per_all_assignments_f SS,
355: pay_action_interlocks AI,
356: pay_assignment_actions AA,
357: pay_payroll_actions PA
358: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
359: ('TRANSFER_PAYROLL_ACTION_ID')
360: AND AA.payroll_action_id = PA.payroll_action_id

Line 390: pay_assignment_actions paa

386: from ff_archive_items fai,
387: ff_contexts fc, -- JD
388: ff_database_items fdi,
389: ff_archive_item_contexts faic, -- JD
390: pay_assignment_actions paa
391: where paa.assignment_action_id
392: = pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID')
393: and paa.assignment_action_id = fai.context1
394: and fdi.user_name = 'A_COUNTY_WITHHELD_PER_JD_GRE_YTD'

Line 412: pay_assignment_actions paa

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

Line 445: pay_assignment_actions AA,

441: 'TAX_UNIT_ID=C',AA.TAX_UNIT_ID
442: FROM per_all_people_f PE,
443: per_all_assignments_f SS,
444: pay_action_interlocks AI,
445: pay_assignment_actions AA,
446: pay_payroll_actions PA
447: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
448: ('TRANSFER_PAYROLL_ACTION_ID')
449: AND aa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')