DBA Data[Home] [Help]

APPS.PAY_MX_DIM_MAG dependencies on PAY_ACTION_INTERLOCKS

Line 721: ,pay_action_interlocks pai

717: ||ltrim(rtrim(MATERNAL_LAST_NAME)) ||' '
718: ||ltrim(rtrim(NAMES)) FULL_NAME
719: FROM pay_mx_isr_tax_format37_v dim
720: ,pay_assignment_actions paa
721: ,pay_action_interlocks pai
722: WHERE dim.payroll_action_id = paa.payroll_action_id
723: AND dim.person_id = to_number(paa.serial_number)
724: AND paa.assignment_action_id = pai.locked_action_id
725: AND pai.locking_action_id = cp_assignment_action_id