DBA Data[Home] [Help]

APPS.PAY_NL_NSI_PROCESS dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 1545: SELECT pay_assignment_actions_s.NEXTVAL

1541: -- Create Archive Assignment Action for Assignment
1542: IF l_Prev_Assignment_ID IS NULL
1543: OR l_Prev_Assignment_ID <> l_Assignment_ID
1544: OR l_asg_act_id IS NULL THEN
1545: SELECT pay_assignment_actions_s.NEXTVAL
1546: INTO l_asg_act_id
1547: FROM dual;
1548: --
1549: -- Create the archive assignment action

Line 1771: SELECT pay_assignment_actions_s.NEXTVAL

1767: p_Withdraw_New_Hire:= TRUE;
1768: END IF;
1769: -- Create Archive Assignment Action for Assignment
1770: IF l_asg_act_id IS NULL THEN
1771: SELECT pay_assignment_actions_s.NEXTVAL
1772: INTO l_asg_act_id
1773: FROM dual;
1774: --
1775: -- Create the archive assignment action