DBA Data[Home] [Help]

APPS.PER_NL_LTSR_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 1935: FROM pay_action_interlocks

1931: WHERE source_action_id = c_assignment_action_id;
1932: /**************************************************************************/
1933: CURSOR get_parent_asg_ids(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1934: SELECT locked_action_id parent_id
1935: FROM pay_action_interlocks
1936: WHERE locking_action_id = c_assignment_action_id;
1937: /**************************************************************************/
1938: CURSOR get_pact_id(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1939: SELECT ppa.payroll_action_id