APPS.PAY_NL_CBS_FILE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 882: from pay_payroll_actions ppa,pay_assignment_Actions paa

878: RETURN NUMBER IS
879:
880: cursor csr_get_date_earned(p_asg_act_id number) is
881: select date_earned
882: from pay_payroll_actions ppa,pay_assignment_Actions paa
883: where
884: ppa.payroll_action_id = paa.payroll_action_id
885: and paa.assignment_action_id = p_max_assgt_act_id;
886:

Line 1596: SELECT pay_assignment_actions_s.NEXTVAL

1592: /*Create the Assignment Action for the Assignments */
1593:
1594: -- hr_utility.set_location('creating asg_act_id'||l_asg_act_id,600);
1595:
1596: SELECT pay_assignment_actions_s.NEXTVAL
1597: INTO l_asg_act_id
1598: FROM dual;
1599:
1600: -- hr_utility.set_location('new l_asg_act_id'||l_asg_act_id,600);