DBA Data[Home] [Help]

APPS.PAY_CORE_FF_UDFS dependencies on PAY_ACTION_INTERLOCKS

Line 3373: pay_action_interlocks pai

3369: AND NOT EXISTS (
3370: SELECT 1
3371: FROM pay_payroll_actions ppa_rev,
3372: pay_assignment_actions paa_rev,
3373: pay_action_interlocks pai
3374: WHERE pai.locked_Action_id = paa_run.assignment_action_id
3375: AND pai.locking_action_id = paa_rev.assignment_action_id
3376: AND ppa_rev.payroll_action_id = paa_rev.payroll_action_id
3377: AND ppa_rev.action_type = 'V');

Line 3400: pay_action_interlocks pai

3396: AND NOT EXISTS (
3397: SELECT 1
3398: FROM pay_payroll_actions ppa_rev,
3399: pay_assignment_actions paa_rev,
3400: pay_action_interlocks pai
3401: WHERE pai.locked_Action_id = paa_run.assignment_action_id
3402: AND pai.locking_action_id = paa_rev.assignment_action_id
3403: AND ppa_rev.payroll_action_id = paa_rev.payroll_action_id
3404: AND ppa_rev.action_type = 'V');