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 132: processor while the pay_assignment_actions looks for

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

Line 156: pay_assignment_actions AA

152: 'TAX_UNIT_NAME=P' , hou.name,
153: 'TRANSFER_EMP_CODE=P', 'R'
154: FROM hr_all_organization_units hou,
155: pay_payroll_actions ppa,
156: pay_assignment_actions AA
157: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
158: ('TRANSFER_PAYROLL_ACTION_ID')
159: AND ppa.report_type = 'YREND'
160: AND to_char(ppa.effective_date,'YYYY')

Line 180: pay_assignment_actions AA

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

Line 205: pay_assignment_actions AA

201: 'TAX_UNIT_NAME=P', hou.name,
202: 'TRANSFER_EMP_CODE=P' , 'R'
203: FROM hr_all_organization_units hou,
204: pay_payroll_actions ppa,
205: pay_assignment_actions AA
206: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
207: ('TRANSFER_PAYROLL_ACTION_ID')
208: AND ppa.report_type = 'YREND'
209: AND to_char(ppa.effective_date,'YYYY')

Line 227: pay_assignment_actions AA

223: 'TAX_UNIT_NAME=P', hou.name,
224: 'TRANSFER_EMP_CODE=P' , 'Q'
225: FROM hr_all_organization_units hou,
226: pay_payroll_actions ppa,
227: pay_assignment_actions AA
228: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
229: ('TRANSFER_PAYROLL_ACTION_ID')
230: AND ppa.report_type = 'YREND'
231: AND to_char(ppa.effective_date,'YYYY')

Line 257: FROM pay_assignment_actions paa

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

Line 275: pay_assignment_actions AA,

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

Line 307: pay_assignment_actions AA,

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

Line 308: pay_assignment_actions paa,

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

Line 355: pay_assignment_actions AA,

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

Line 389: pay_assignment_actions paa

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

Line 411: pay_assignment_actions paa

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

Line 444: pay_assignment_actions AA,

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