APPS.HR_NL_ASG_EXTRA_INFO_CHECKS dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 31: , per_assignment_extra_info paei

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'
35: AND paaf.assignment_id=paei.assignment_id

Line 43: FROM per_assignment_extra_info paei

39:
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;

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: