DBA Data[Home] [Help]

APPS.PER_NL_LTSRR_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 2022: FROM pay_action_interlocks

2018: WHERE source_action_id = c_assignment_action_id;
2019: /**************************************************************************/
2020: CURSOR get_parent_asg_ids(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2021: SELECT locked_action_id parent_id
2022: FROM pay_action_interlocks
2023: WHERE locking_action_id = c_assignment_action_id;
2024: /**************************************************************************/
2025: CURSOR get_pact_id(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2026: SELECT ppa.payroll_action_id