APPS.PQP_BUDGET_MAINTENANCE dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 627: FROM hr_assignment_set_amendments

623: CURSOR csr_get_asg_amnd(c_asg_set_id NUMBER)
624: IS
625: SELECT assignment_id, NVL(include_or_exclude
626: ,'I') include_or_exclude
627: FROM hr_assignment_set_amendments
628: WHERE assignment_set_id = c_asg_set_id;
629:
630: l_proc_step NUMBER(38, 10) := 0;
631: l_proc_name VARCHAR2(61)

Line 750: FROM hr_assignment_set_amendments

746: -- has an inclusion
747: CURSOR csr_get_asg_amnd_incl(c_asg_set_id NUMBER)
748: IS
749: SELECT 'X'
750: FROM hr_assignment_set_amendments
751: WHERE assignment_set_id = c_asg_set_id
752: AND NVL(include_or_exclude, 'I') =
753: 'I' -- hard coded as it's from lookup code
754: AND ROWNUM < 2;

Line 938: -- ,hr_assignment_set_amendments haa

934: -- AS SELECT DISTINCT paa.person_id
935: -- ,paa.assignment_id
936: -- ,haa.include_or_exclude
937: -- FROM per_all_assignments_f paa
938: -- ,hr_assignment_set_amendments haa
939: -- WHERE paa.assignment_id = haa.assignment_id
940: -- AND haa.assignment_set_id = '
941: -- || l_assignment_set_id;
942: -- EXECUTE IMMEDIATE l_create_string;

Line 963: ,hr_assignment_set_amendments hasa

959: l_proc_step := 70;
960: l_string :=
961: 'SELECT DISTINCT person_id
962: FROM per_all_assignments_f paa
963: ,hr_assignment_set_amendments hasa
964: ,pay_payroll_actions ppa
965: WHERE paa.business_group_id = ppa.business_group_id
966: AND ppa.payroll_action_id = :payroll_action_id
967: AND paa.assignment_id = hasa.assignment_id

Line 1245: ,hr_assignment_set_amendments hasa

1241: )
1242: IS
1243: SELECT asg.assignment_id
1244: FROM per_all_assignments_f asg
1245: ,hr_assignment_set_amendments hasa
1246: WHERE asg.assignment_id = hasa.assignment_id
1247: AND hasa.assignment_set_id = c_assignment_set_id
1248: AND NVL(hasa.include_or_exclude, 'I') = 'I'
1249: AND asg.person_id BETWEEN p_start_person AND p_end_person