DBA Data[Home] [Help]

APPS.PER_VACANCIES_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 142: PER_ASSIGNMENT_STATUS_TYPES a

138:
139: CURSOR csr_counter IS
140: SELECT COUNT(distinct ass.assignment_id)
141: FROM PER_ALL_ASSIGNMENTS ASS,
142: PER_ASSIGNMENT_STATUS_TYPES a
143: where nvl(A.BUSINESS_GROUP_ID,P_Business_group_id) =
144: P_Business_group_id
145: and ass.business_group_id + 0 = P_Business_group_id
146: and ass.ASSIGNMENT_TYPE = 'A'