DBA Data[Home] [Help]

APPS.PAY_MX_FORMAT_2D dependencies on PAY_ACTION_INTERLOCKS

Line 580: ,pay_action_interlocks pai

576: ,nvl(TOTAL_SUBJECT_EARNINGS,0)+
577: nvl(TOTAL_EXEMPT_EARNINGS,0) TOTAL_EARNINGS
578: FROM pay_mx_isr_tax_format37_v format2d
579: ,pay_assignment_actions paa
580: ,pay_action_interlocks pai
581: WHERE format2d.payroll_action_id = paa.payroll_action_id
582: AND format2d.person_id = to_number(paa.serial_number)
583: AND paa.assignment_action_id = pai.locked_action_id
584: AND pai.locking_action_id = cp_assignment_action_id