APPS.PQP_BUDGET_MAINTENANCE dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 616: FROM hr_assignment_set_amendments

612: CURSOR csr_get_asg_amnd(c_asg_set_id NUMBER)
613: IS
614: SELECT assignment_id, NVL(include_or_exclude
615: ,'I') include_or_exclude
616: FROM hr_assignment_set_amendments
617: WHERE assignment_set_id = c_asg_set_id;
618:
619: l_proc_step NUMBER(38, 10) := 0;
620: l_proc_name VARCHAR2(61)

Line 739: FROM hr_assignment_set_amendments

735: -- has an inclusion
736: CURSOR csr_get_asg_amnd_incl(c_asg_set_id NUMBER)
737: IS
738: SELECT 'X'
739: FROM hr_assignment_set_amendments
740: WHERE assignment_set_id = c_asg_set_id
741: AND NVL(include_or_exclude, 'I') =
742: 'I' -- hard coded as it's from lookup code
743: AND ROWNUM < 2;

Line 927: -- ,hr_assignment_set_amendments haa

923: -- AS SELECT DISTINCT paa.person_id
924: -- ,paa.assignment_id
925: -- ,haa.include_or_exclude
926: -- FROM per_all_assignments_f paa
927: -- ,hr_assignment_set_amendments haa
928: -- WHERE paa.assignment_id = haa.assignment_id
929: -- AND haa.assignment_set_id = '
930: -- || l_assignment_set_id;
931: -- EXECUTE IMMEDIATE l_create_string;

Line 952: ,hr_assignment_set_amendments hasa

948: l_proc_step := 70;
949: l_string :=
950: 'SELECT DISTINCT person_id
951: FROM per_all_assignments_f paa
952: ,hr_assignment_set_amendments hasa
953: ,pay_payroll_actions ppa
954: WHERE paa.business_group_id = ppa.business_group_id
955: AND ppa.payroll_action_id = :payroll_action_id
956: AND paa.assignment_id = hasa.assignment_id

Line 1233: ,hr_assignment_set_amendments hasa

1229: )
1230: IS
1231: SELECT asg.assignment_id
1232: FROM per_all_assignments_f asg
1233: ,hr_assignment_set_amendments hasa
1234: WHERE asg.assignment_id = hasa.assignment_id
1235: AND hasa.assignment_set_id = c_assignment_set_id
1236: AND NVL(hasa.include_or_exclude, 'I') = 'I'
1237: AND asg.person_id BETWEEN p_start_person AND p_end_person