APPS.PA_RESOURCE_PUB dependencies on PA_RESOURCE_TYPES

Line 1205: , pa_resource_types rt

1201: WHERE EXISTS
1202: (SELECT 'x'
1203: FROM pa_resource_list_members rlm
1204: , pa_resources r
1205: , pa_resource_types rt
1206: WHERE
1207: rlm.resource_list_id = l_resource_list_id
1208: AND rlm.resource_id = r.resource_id
1209: AND r.resource_type_id = rt.resource_type_id

Line 1217: FROM pa_resource_types_active_v rta

1213: -- Validate Resource Type Id
1214: CURSOR l_resource_type_csr (p_grouped_by_type VARCHAR2)
1215: IS
1216: SELECT rta.resource_type_id
1217: FROM pa_resource_types_active_v rta
1218: WHERE rta.resource_type_code = p_grouped_by_type;
1219:
1220: -- Get Original Updatable Columns on PA_RESOURCE_LISTS
1221:

Line 3248: pa_resource_types rt

3244: IS
3245: SELECT rlm.ROWID, rlm.resource_list_member_id
3246: FROM pa_resource_list_members rlm,
3247: pa_resources r,
3248: pa_resource_types rt
3249: WHERE rlm.resource_id = r.resource_id
3250: AND r.resource_type_id = rt.resource_type_id
3251: AND rt.resource_type_code <> 'UNCLASSIFIED'
3252: AND rlm.resource_list_id = l_resource_list_id

Line 3264: pa_resource_types rt

3260: IS
3261: SELECT rlm.ROWID
3262: FROM pa_resource_list_members rlm,
3263: pa_resources r,
3264: pa_resource_types rt
3265: WHERE rlm.resource_id = r.resource_id
3266: AND rlm.parent_member_id = l_rg_rlm_id
3267: AND r.resource_type_id = rt.resource_type_id
3268: AND rt.resource_type_code <> 'UNCLASSIFIED'