DBA Data[Home] [Help]

APPS.PY_ZA_ROUTES dependencies on PAY_ACTION_INTERLOCKS

Line 475: pay_action_interlocks INTLK,

471: pay_run_result_values TARGET,
472: pay_run_results RR,
473: pay_payroll_actions PACT,
474: pay_assignment_actions ASSACT,
475: pay_action_interlocks INTLK,
476: pay_payroll_actions BACT,
477: pay_assignment_actions BAL_ASSACT
478: where BAL_ASSACT.assignment_action_id = assact_id
479: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 497: pay_action_interlocks RINTLK

493: and not exists
494: (select null
495: from pay_payroll_actions RPACT,
496: pay_assignment_actions RASSACT,
497: pay_action_interlocks RINTLK
498: where ASSACT.assignment_action_id = RINTLK.locked_action_id
499: and RINTLK.locking_action_id = RASSACT.assignment_action_id
500: and RPACT.payroll_action_id = RASSACT.payroll_action_id
501: and RPACT.action_type = 'V');