APPS.PAY_US_MMREF_REPORTING dependencies on PAY_ASSIGNMENT_ACTIONS

Line 182: processor while the pay_assignment_actions looks for

178: --
179: --
180: /* Context and Parameter in the cursor are
181: Payroll_action_id table looks for value related to Year End pre-
182: processor while the pay_assignment_actions looks for
183: assignment actions of Mag. tapes
184: Context :
185: TAX_UNIT_ID - Submitter's Tax Unit ID
186: JURISDICTION_CODE - Set to Dummy Value as This is federal Cursor

Line 206: pay_assignment_actions AA

202: 'TAX_UNIT_NAME=P' , hou.name,
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 231: pay_assignment_actions AA

227: 'TAX_UNIT_NAME=P', hou.name,
228: 'TRANSFER_EMP_CODE=P' , 'R'
229: FROM hr_all_organization_units hou,
230: pay_payroll_actions ppa,
231: pay_assignment_actions AA
232: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
233: ('TRANSFER_PAYROLL_ACTION_ID')
234: AND ppa.report_type = 'YREND'
235: AND to_char(ppa.effective_date,'YYYY')

Line 253: pay_assignment_actions AA

249: 'TAX_UNIT_NAME=P', hou.name,
250: 'TRANSFER_EMP_CODE=P' , 'Q'
251: FROM hr_all_organization_units hou,
252: pay_payroll_actions ppa,
253: pay_assignment_actions AA
254: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
255: ('TRANSFER_PAYROLL_ACTION_ID')
256: AND ppa.report_type = 'YREND'
257: AND to_char(ppa.effective_date,'YYYY')

Line 283: pay_assignment_actions AA,

279: (PA.effective_date, AA.assignment_id)),
280: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
281: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
282: FROM pay_payroll_actions PA,
283: pay_assignment_actions AA,
284: pay_action_interlocks AI,
285: per_all_assignments_f SS,
286: per_all_people_f PE
287: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 318: pay_assignment_actions AA,

314: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
315: FROM per_all_people_f PE,
316: per_all_assignments_f SS,
317: pay_action_interlocks AI,
318: pay_assignment_actions AA,
319: pay_assignment_actions paa,
320: pay_payroll_actions PA,
321: ff_archive_items arch,
322: ff_user_entities fue

Line 319: pay_assignment_actions paa,

315: FROM per_all_people_f PE,
316: per_all_assignments_f SS,
317: pay_action_interlocks AI,
318: pay_assignment_actions AA,
319: pay_assignment_actions paa,
320: pay_payroll_actions PA,
321: ff_archive_items arch,
322: ff_user_entities fue
323: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 366: pay_assignment_actions AA,

362: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
363: FROM per_all_people_f PE,
364: per_all_assignments_f SS,
365: pay_action_interlocks AI,
366: pay_assignment_actions AA,
367: pay_payroll_actions PA
368: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
369: ('TRANSFER_PAYROLL_ACTION_ID')
370: AND AA.payroll_action_id = PA.payroll_action_id

Line 400: pay_assignment_actions paa

396: from ff_archive_items fai,
397: ff_contexts fc, -- JD
398: ff_database_items fdi,
399: ff_archive_item_contexts faic, -- JD
400: pay_assignment_actions paa
401: where paa.assignment_action_id
402: = pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID')
403: and paa.assignment_action_id = fai.context1
404: and fdi.user_name = 'A_COUNTY_WITHHELD_PER_JD_GRE_YTD'

Line 422: pay_assignment_actions paa

418: from ff_archive_items fai,
419: ff_contexts fc, -- JD
420: ff_database_items fdi,
421: ff_archive_item_contexts faic, -- JD
422: pay_assignment_actions paa
423: where paa.assignment_action_id =
424: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID')
425: and paa.assignment_action_id = fai.context1
426: and (fdi.user_name = 'A_SCHOOL_WITHHELD_PER_JD_GRE_YTD' OR