APPS.PA_PLANNING_RESOURCE_PVT dependencies on PA_RES_TYPES_B

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

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

Line 243: FROM pa_res_types_b

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

Line 982: from pa_res_formats_b fmt,pa_res_types_b res

978:
979: BEGIN
980: SELECT res.res_type_code
981: INTO l_res_type_code
982: from pa_res_formats_b fmt,pa_res_types_b res
983: where fmt.res_type_id = res.res_type_id
984: and fmt.res_format_id = p_res_format_id;
985: EXCEPTION
986: WHEN NO_DATA_FOUND THEN