APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_WORK_TYPES_V

Line 1299: pa_work_types_v wt

1295: pa_projects_all proj,
1296: pa_project_role_types prt,
1297: pa_lookups sp,
1298: pa_lookups fcst,
1299: pa_work_types_v wt
1300: WHERE assignment_id = p_assignment_id
1301: AND asgn.project_role_id = prt.project_role_id
1302: AND asgn.project_id = proj.project_id
1303: AND sp.lookup_type(+) = 'STAFFING_PRIORITY_CODE'