DBA Data[Home] [Help]

APPS.PAY_CORE_FF_UDFS dependencies on PAY_ACTION_INTERLOCKS

Line 3792: pay_action_interlocks pai

3788: AND NOT EXISTS (
3789: SELECT 1
3790: FROM pay_payroll_actions ppa_rev,
3791: pay_assignment_actions paa_rev,
3792: pay_action_interlocks pai
3793: WHERE pai.locked_Action_id = paa_run.assignment_action_id
3794: AND pai.locking_action_id = paa_rev.assignment_action_id
3795: AND ppa_rev.payroll_action_id = paa_rev.payroll_action_id
3796: AND ppa_rev.action_type = 'V');

Line 3819: pay_action_interlocks pai

3815: AND NOT EXISTS (
3816: SELECT 1
3817: FROM pay_payroll_actions ppa_rev,
3818: pay_assignment_actions paa_rev,
3819: pay_action_interlocks pai
3820: WHERE pai.locked_Action_id = paa_run.assignment_action_id
3821: AND pai.locking_action_id = paa_rev.assignment_action_id
3822: AND ppa_rev.payroll_action_id = paa_rev.payroll_action_id
3823: AND ppa_rev.action_type = 'V');