APPS.GHR_MSL_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 51: per_assignment_status_types pas_t

47: paf.business_group_id BUSINESS_GROUP_ID
48: from per_assignments_f paf,
49: per_people_f ppf,
50: per_person_types ppt,
51: per_assignment_status_types pas_t
52: where ppf.person_id = paf.person_id
53: and paf.primary_flag = 'Y'
54: and paf.assignment_type <> 'B'
55: and paf.assignment_status_type_id = pas_t.assignment_status_type_id

Line 157: SELECT user_status from per_assignment_status_types

153: -- Check assignment_status_type
154: --
155:
156: CURSOR cur_ast (asg_status_type_id number) IS
157: SELECT user_status from per_assignment_status_types
158: WHERE assignment_status_type_id = asg_status_type_id
159: AND upper(user_status) not in (
160: 'TERMINATE ASSIGNMENT', /* 3 */
161: 'ACTIVE APPLICATION', /* 4 */

Line 5062: select user_status from per_assignment_status_types

5058: -- Check assignment_status_type
5059: --
5060:
5061: cursor cur_ast (asg_status_type_id number) is
5062: select user_status from per_assignment_status_types
5063: where assignment_status_type_id = asg_status_type_id
5064: and upper(user_status) not in (
5065: 'TERMINATE ASSIGNMENT', /* 3 */
5066: 'ACTIVE APPLICATION', /* 4 */

Line 7198: from per_assignment_status_types

7194:
7195: cursor cur_ast (asg_status_type_id number)
7196: is
7197: select user_status
7198: from per_assignment_status_types
7199: where assignment_status_type_id = asg_status_type_id
7200: and upper(user_status) not in (
7201: 'TERMINATE ASSIGNMENT', /* 3 */
7202: 'ACTIVE APPLICATION', /* 4 */