DBA Data[Home] [Help]

APPS.PER_NL_DSRR_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 1996: FROM pay_action_interlocks

1992: WHERE source_action_id = c_assignment_action_id;
1993: /**************************************************************************/
1994: CURSOR get_parent_asg_ids(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1995: SELECT locked_action_id parent_id
1996: FROM pay_action_interlocks
1997: WHERE locking_action_id = c_assignment_action_id;
1998: /**************************************************************************/
1999: CURSOR get_pact_id(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2000: SELECT ppa.payroll_action_id