APPS.HR_NL_ASG_EXTRA_INFO_CHECKS dependencies on PER_ALL_ASSIGNMENTS_F

Line 30: FROM per_all_assignments_f paaf1

26: ,P_AEI_INFORMATION1 in VARCHAR2) IS
27:
28: CURSOR csr_assignments IS
29: SELECT paaf1.assignment_id
30: FROM per_all_assignments_f paaf1
31: , per_assignment_extra_info paei
32: , per_all_assignments_f paaf
33: WHERE paei.assignment_extra_info_id=P_ASSIGNMENT_EXTRA_INFO_ID
34: AND paei.information_type='NL_NUMIV_OVERRIDE'

Line 32: , per_all_assignments_f paaf

28: CURSOR csr_assignments IS
29: SELECT paaf1.assignment_id
30: FROM per_all_assignments_f paaf1
31: , per_assignment_extra_info paei
32: , per_all_assignments_f paaf
33: WHERE paei.assignment_extra_info_id=P_ASSIGNMENT_EXTRA_INFO_ID
34: AND paei.information_type='NL_NUMIV_OVERRIDE'
35: AND paaf.assignment_id=paei.assignment_id
36: AND paaf.person_id=paaf1.person_id

Line 44: , per_all_assignments_f paaf

40: CURSOR csr_numiv_override (c_asg_id number)is
41: SELECT aei_information1 NUMIV_OVERRIDE
42: , paaf.assignment_sequence ASSIGNMENT_SEQUENCE
43: FROM per_assignment_extra_info paei
44: , per_all_assignments_f paaf
45: WHERE paaf.assignment_id = c_asg_id
46: AND paei.aei_information_category(+) = 'NL_NUMIV_OVERRIDE'
47: AND paei.assignment_id(+)= paaf.assignment_id;
48:

Line 89: FROM per_all_assignments_f paaf1

85:
86:
87: cursor csr_assignments is
88: SELECT paaf1.assignment_id
89: FROM per_all_assignments_f paaf1
90: , per_all_assignments_f paaf
91: WHERE paaf.assignment_id=P_ASSIGNMENT_ID
92: AND paaf.person_id=paaf1.person_id
93: AND paaf1.assignment_id <>paaf.assignment_id

Line 90: , per_all_assignments_f paaf

86:
87: cursor csr_assignments is
88: SELECT paaf1.assignment_id
89: FROM per_all_assignments_f paaf1
90: , per_all_assignments_f paaf
91: WHERE paaf.assignment_id=P_ASSIGNMENT_ID
92: AND paaf.person_id=paaf1.person_id
93: AND paaf1.assignment_id <>paaf.assignment_id
94: AND paaf1.assignment_type = 'E'; --11723380

Line 99: FROM per_assignment_extra_info paei, per_all_assignments_f paaf

95:
96: CURSOR csr_numiv_override (c_asg_id number)is
97: SELECT aei_information1 NUMIV_OVERRIDE
98: , paaf.assignment_sequence ASSIGNMENT_SEQUENCE
99: FROM per_assignment_extra_info paei, per_all_assignments_f paaf
100: WHERE paaf.assignment_id = c_asg_id
101: AND paei.aei_information_category(+) = 'NL_NUMIV_OVERRIDE'
102: AND paei.assignment_id(+)= paaf.assignment_id;
103: