DBA Data[Home] [Help]

APPS.PER_NL_DSR_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 2988: FROM pay_action_interlocks

2984: WHERE source_action_id = c_assignment_action_id;
2985: /**************************************************************************/
2986: CURSOR get_parent_asg_ids(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2987: SELECT locked_action_id parent_id
2988: FROM pay_action_interlocks
2989: WHERE locking_action_id = c_assignment_action_id;
2990: /**************************************************************************/
2991: CURSOR get_pact_id(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2992: SELECT ppa.payroll_action_id