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 153: SELECT user_status from per_assignment_status_types

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

Line 5000: select user_status from per_assignment_status_types

4996: -- Check assignment_status_type
4997: --
4998:
4999: cursor cur_ast (asg_status_type_id number) is
5000: select user_status from per_assignment_status_types
5001: where assignment_status_type_id = asg_status_type_id
5002: and upper(user_status) not in (
5003: 'TERMINATE ASSIGNMENT', /* 3 */
5004: 'ACTIVE APPLICATION', /* 4 */

Line 7052: from per_assignment_status_types

7048:
7049: cursor cur_ast (asg_status_type_id number)
7050: is
7051: select user_status
7052: from per_assignment_status_types
7053: where assignment_status_type_id = asg_status_type_id
7054: and upper(user_status) not in (
7055: 'TERMINATE ASSIGNMENT', /* 3 */
7056: 'ACTIVE APPLICATION', /* 4 */