APPS.PQP_BUDGET_MAINTENANCE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1233: SELECT pay_assignment_actions_s.NEXTVAL

1229:
1230: -- Cursor to get next value from assignment action seq
1231: CURSOR csr_get_asg_action_seq
1232: IS
1233: SELECT pay_assignment_actions_s.NEXTVAL
1234: FROM DUAL;
1235:
1236: -- Cursor to get assignments from assignment amendments
1237: -- that does not fall within the effective date range

Line 1505: -- insert into pay_assignment_actions

1501: , RPAD('Assignment Action Id', 30)
1502: || ': '
1503: || l_asg_action_seq
1504: );
1505: -- insert into pay_assignment_actions
1506: hr_nonrun_asact.insact(l_asg_action_seq
1507: ,l_asg_rec.assignment_id
1508: ,p_pay_action_id
1509: ,p_chunk

Line 1590: FROM pay_assignment_actions

1586: IS
1587: CURSOR csr_assignment_id(p_assignment_action_id NUMBER)
1588: IS
1589: SELECT assignment_id, payroll_action_id
1590: FROM pay_assignment_actions
1591: WHERE assignment_action_id = p_assignment_action_id;
1592:
1593: l_asg_action_details csr_assignment_id%ROWTYPE;
1594: l_proc_step NUMBER(38, 10) := 0;

Line 3793: FROM pay_assignment_actions

3789: -- complete
3790: CURSOR csr_get_comp_asg_acts
3791: IS
3792: SELECT assignment_action_id
3793: FROM pay_assignment_actions
3794: WHERE payroll_action_id = p_pay_action_id AND action_status = 'C';
3795:
3796: -- Cursor to get count of assignment actions for
3797: -- a given payroll action

Line 3801: FROM pay_assignment_actions

3797: -- a given payroll action
3798: CURSOR csr_get_asg_act_cnt
3799: IS
3800: SELECT COUNT(*)
3801: FROM pay_assignment_actions
3802: WHERE payroll_action_id = p_pay_action_id;
3803:
3804: l_proc_step NUMBER(38, 10) := 0;
3805: l_proc_name VARCHAR2(61)

Line 3856: DELETE FROM pay_assignment_actions

3852: END IF;
3853:
3854: l_proc_step := 40;
3855: -- Delete from assignment actions
3856: DELETE FROM pay_assignment_actions
3857: WHERE assignment_action_id = l_asg_action_id;
3858:
3859: IF g_debug
3860: THEN