APPS.PA_ASSIGNMENTS_PUB dependencies on PA_WORK_TYPES_B

Line 139: FROM PA_WORK_TYPES_B B

135:
136: -- start of cursor or work type validation bug 8368384
137: CURSOR c_validate_work_type (p_wrk_typ_id number,p_start_dt Date, p_end_dt Date) IS
138: SELECT 'Y' Flag
139: FROM PA_WORK_TYPES_B B
140: WHERE B.work_type_id = p_wrk_typ_id
141: AND TRUNC(SYSDATE) BETWEEN start_date_active
142: AND NVL(end_date_active,TRUNC(SYSDATE));
143: BEGIN