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