DBA Data[Home] [Help]

APPS.PAY_US_PSD_XML dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 281: ff_archive_item_contexts faic,

277: AND paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
278: AND length(puar.jurisdiction_code)=16
279: AND EXISTS ( select null
280: from ff_archive_items fai,
281: ff_archive_item_contexts faic,
282: FF_CONTEXTS FC
283: WHERE fai.context1 = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
284: and fai.archive_item_id = faic.archive_item_id
285: and faic.CONTEXT_ID = FC.CONTEXT_ID

Line 310: ff_archive_item_contexts faic,

306: AND ( ( pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(PpA.payroll_action_id,
307: 'TRANSFER_PERIOD_TYPE') <> 'Yearly'
308: and EXISTS ( select null
309: from ff_archive_items fai,
310: ff_archive_item_contexts faic,
311: FF_CONTEXTS FC
312: WHERE fai.context1 = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
313: and fai.archive_item_id = faic.archive_item_id
314: and faic.CONTEXT_ID = FC.CONTEXT_ID

Line 321: ff_archive_item_contexts faic,

317: OR ( pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(PpA.payroll_action_id,
318: 'TRANSFER_PERIOD_TYPE') = 'Yearly'
319: AND EXISTS ( select null
320: from ff_archive_items fai,
321: ff_archive_item_contexts faic,
322: FF_CONTEXTS FC,
323: PAY_ACTION_INTERLOCKS pai
324: WHERE fai.context1 = pai.locked_action_id
325: and pai.locking_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')