APPS.PA_PLANNING_RESOURCE_PVT dependencies on PA_RES_TYPES_B

Line 243: Cursor get_res_type(p_res_type_id pa_res_types_b.res_type_id%TYPE )

239: SELECT res_type_id,res_type_enabled_flag,
240: resource_class_flag
241: FROM pa_res_formats_b
242: WHERE res_format_id = p_res_format_id;
243: Cursor get_res_type(p_res_type_id pa_res_types_b.res_type_id%TYPE )
244: IS
245: SELECT res_type_code
246: FROM pa_res_types_b
247: WHERE res_type_id = p_res_type_id;

Line 246: FROM pa_res_types_b

242: WHERE res_format_id = p_res_format_id;
243: Cursor get_res_type(p_res_type_id pa_res_types_b.res_type_id%TYPE )
244: IS
245: SELECT res_type_code
246: FROM pa_res_types_b
247: WHERE res_type_id = p_res_type_id;
248: /**************************************
249: * Local Variable Declaration
250: *************************************/

Line 1085: from pa_res_formats_b fmt,pa_res_types_b res

1081:
1082: BEGIN
1083: SELECT res.res_type_code
1084: INTO l_res_type_code
1085: from pa_res_formats_b fmt,pa_res_types_b res
1086: where fmt.res_type_id = res.res_type_id
1087: and fmt.res_format_id = p_res_format_id;
1088: EXCEPTION
1089: WHEN NO_DATA_FOUND THEN