APPS.PAY_US_PSD_XML dependencies on PAY_ACTION_INTERLOCKS

Line 323: PAY_ACTION_INTERLOCKS pai

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')
326: and fai.archive_item_id = faic.archive_item_id
327: and faic.CONTEXT_ID = FC.CONTEXT_ID

Line 334: from PAY_ACTION_INTERLOCKS pai

330: );
331: /* OR ( pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(PpA.payroll_action_id,
332: 'TRANSFER_PERIOD_TYPE') = 'Yearly'
333: AND EXISTS ( select null
334: from PAY_ACTION_INTERLOCKS pai
335: WHERE pai.locking_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
336: AND EXISTS ( SELECT NULL
337: from PAY_US_LOCALITY_W2_V v
338: where v.assignment_action_id = pai.locked_action_id