APPS.HR_ASSIGNMENT_SET dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 46: SELECT 'Y' FROM hr_assignment_set_amendments

42:
43:
44:
45: CURSOR c_assignment_set(c_assignmentset_id number,c_assignment_id number) IS
46: SELECT 'Y' FROM hr_assignment_set_amendments
47: WHERE assignment_set_id = c_assignmentset_id
48: AND assignment_id = c_assignment_id
49: AND upper(include_or_exclude) = 'I';
50:

Line 94: hr_assignment_set_amendments hasa

90:
91: CURSOR c_person_set(c_assignmentset_id number,c_person_id number) IS
92: select 'Y' from
93: per_assignments_f paf,
94: hr_assignment_set_amendments hasa
95: where
96: hasa.assignment_set_id = C_ASSIGNMENTSET_ID AND
97: hasa.ASSIGNMENT_ID = paf.assignment_id AND
98: UPPER(hasa.include_or_exclude) = 'I' AND