APPS.PQP_BUDGET_MAINTENANCE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1221: SELECT pay_assignment_actions_s.NEXTVAL

1217:
1218: -- Cursor to get next value from assignment action seq
1219: CURSOR csr_get_asg_action_seq
1220: IS
1221: SELECT pay_assignment_actions_s.NEXTVAL
1222: FROM DUAL;
1223:
1224: -- Cursor to get assignments from assignment amendments
1225: -- that does not fall within the effective date range

Line 1493: -- insert into pay_assignment_actions

1489: , RPAD('Assignment Action Id', 30)
1490: || ': '
1491: || l_asg_action_seq
1492: );
1493: -- insert into pay_assignment_actions
1494: hr_nonrun_asact.insact(l_asg_action_seq
1495: ,l_asg_rec.assignment_id
1496: ,p_pay_action_id
1497: ,p_chunk

Line 1578: FROM pay_assignment_actions

1574: IS
1575: CURSOR csr_assignment_id(p_assignment_action_id NUMBER)
1576: IS
1577: SELECT assignment_id, payroll_action_id
1578: FROM pay_assignment_actions
1579: WHERE assignment_action_id = p_assignment_action_id;
1580:
1581: l_asg_action_details csr_assignment_id%ROWTYPE;
1582: l_proc_step NUMBER(38, 10) := 0;

Line 3751: FROM pay_assignment_actions

3747: -- complete
3748: CURSOR csr_get_comp_asg_acts
3749: IS
3750: SELECT assignment_action_id
3751: FROM pay_assignment_actions
3752: WHERE payroll_action_id = p_pay_action_id AND action_status = 'C';
3753:
3754: -- Cursor to get count of assignment actions for
3755: -- a given payroll action

Line 3759: FROM pay_assignment_actions

3755: -- a given payroll action
3756: CURSOR csr_get_asg_act_cnt
3757: IS
3758: SELECT COUNT(*)
3759: FROM pay_assignment_actions
3760: WHERE payroll_action_id = p_pay_action_id;
3761:
3762: l_proc_step NUMBER(38, 10) := 0;
3763: l_proc_name VARCHAR2(61)

Line 3814: DELETE FROM pay_assignment_actions

3810: END IF;
3811:
3812: l_proc_step := 40;
3813: -- Delete from assignment actions
3814: DELETE FROM pay_assignment_actions
3815: WHERE assignment_action_id = l_asg_action_id;
3816:
3817: IF g_debug
3818: THEN