1: PACKAGE body hr_assignment_set AS
2: /* $Header: pyusasst.pkb 120.0 2005/05/29 09:17:43 appldev noship $ */
3:
4: /*
5: +=====================================================================+
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:
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
115: return 'N';
116: END;
117:
118:
119: END HR_ASSIGNMENT_SET;