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

Line 170: processor while the pay_assignment_actions looks for

166: --
167: --
168: /* Context and Parameter in the cursor are
169: Payroll_action_id table looks for value related to Year End pre-
170: processor while the pay_assignment_actions looks for
171: assignment actions of Mag. tapes
172: Context :
173: TAX_UNIT_ID - Submitter's Tax Unit ID
174: JURISDICTION_CODE - Set to Dummy Value as This is federal Cursor

Line 194: pay_assignment_actions AA

190: 'TAX_UNIT_NAME=P' , hou.name,
191: 'TRANSFER_EMP_CODE=P', 'R'
192: FROM hr_all_organization_units hou,
193: pay_payroll_actions ppa,
194: pay_assignment_actions AA
195: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
196: ('TRANSFER_PAYROLL_ACTION_ID')
197: AND ppa.report_type = 'YREND'
198: AND to_char(ppa.effective_date,'YYYY')

Line 218: pay_assignment_actions AA

214: 'TRANSFER_EMP_CODE=P', 'R',
215: 'TRANSFER_TAX_UNIT_ID=P', AA.tax_unit_id
216: FROM hr_all_organization_units hou,
217: pay_payroll_actions ppa,
218: pay_assignment_actions AA
219: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
220: ('TRANSFER_PAYROLL_ACTION_ID')
221: AND ppa.report_type = 'YREND'
222: AND to_char(ppa.effective_date,'YYYY')

Line 243: pay_assignment_actions AA

239: 'TAX_UNIT_NAME=P', hou.name,
240: 'TRANSFER_EMP_CODE=P' , 'R'
241: FROM hr_all_organization_units hou,
242: pay_payroll_actions ppa,
243: pay_assignment_actions AA
244: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
245: ('TRANSFER_PAYROLL_ACTION_ID')
246: AND ppa.report_type = 'YREND'
247: AND to_char(ppa.effective_date,'YYYY')

Line 265: pay_assignment_actions AA

261: 'TAX_UNIT_NAME=P', hou.name,
262: 'TRANSFER_EMP_CODE=P' , 'Q'
263: FROM hr_all_organization_units hou,
264: pay_payroll_actions ppa,
265: pay_assignment_actions AA
266: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
267: ('TRANSFER_PAYROLL_ACTION_ID')
268: AND ppa.report_type = 'YREND'
269: AND to_char(ppa.effective_date,'YYYY')

Line 295: FROM pay_assignment_actions paa

291: 'TRANSFER_ACT_ID')
292: FROM DUAL;
293: */
294: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
295: FROM pay_assignment_actions paa
296: WHERE paa.payroll_action_id =
297: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
298: AND paa.tax_unit_id =
299: pay_magtape_generic.get_parameter_value('TRANSFER_TAX_UNIT_ID');

Line 313: pay_assignment_actions AA,

309: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
310: FROM per_all_people_f PE,
311: per_all_assignments_f SS,
312: pay_action_interlocks AI,
313: pay_assignment_actions AA,
314: pay_payroll_actions PA
315: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
316: ('TRANSFER_PAYROLL_ACTION_ID')
317: AND AA.payroll_action_id = PA.payroll_action_id

Line 346: pay_assignment_actions AA,

342: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
343: FROM per_all_people_f PE,
344: per_all_assignments_f SS,
345: pay_action_interlocks AI,
346: pay_assignment_actions AA,
347: pay_assignment_actions paa,
348: pay_payroll_actions PA,
349: ff_archive_items arch,
350: ff_user_entities fue

Line 347: pay_assignment_actions paa,

343: FROM per_all_people_f PE,
344: per_all_assignments_f SS,
345: pay_action_interlocks AI,
346: pay_assignment_actions AA,
347: pay_assignment_actions paa,
348: pay_payroll_actions PA,
349: ff_archive_items arch,
350: ff_user_entities fue
351: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 394: pay_assignment_actions AA,

390: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
391: FROM per_all_people_f PE,
392: per_all_assignments_f SS,
393: pay_action_interlocks AI,
394: pay_assignment_actions AA,
395: pay_payroll_actions PA
396: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
397: ('TRANSFER_PAYROLL_ACTION_ID')
398: AND AA.payroll_action_id = PA.payroll_action_id

Line 428: pay_assignment_actions paa

424: from ff_archive_items fai,
425: ff_contexts fc, -- JD
426: ff_database_items fdi,
427: ff_archive_item_contexts faic, -- JD
428: pay_assignment_actions paa
429: where paa.assignment_action_id
430: = pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID')
431: and paa.assignment_action_id = fai.context1
432: and fdi.user_name = 'A_COUNTY_WITHHELD_PER_JD_GRE_YTD'

Line 450: pay_assignment_actions paa

446: from ff_archive_items fai,
447: ff_contexts fc, -- JD
448: ff_database_items fdi,
449: ff_archive_item_contexts faic, -- JD
450: pay_assignment_actions paa
451: where paa.assignment_action_id =
452: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID')
453: and paa.assignment_action_id = fai.context1
454: and (fdi.user_name = 'A_SCHOOL_WITHHELD_PER_JD_GRE_YTD' OR

Line 483: pay_assignment_actions AA,

479: 'TAX_UNIT_ID=C',AA.TAX_UNIT_ID
480: FROM per_all_people_f PE,
481: per_all_assignments_f SS,
482: pay_action_interlocks AI,
483: pay_assignment_actions AA,
484: pay_payroll_actions PA
485: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
486: ('TRANSFER_PAYROLL_ACTION_ID')
487: AND aa.assignment_action_id = pay_magtape_generic.get_parameter_value(