APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_RES_TYPES_B

Line 87: FROM pa_res_types_b typ,

83: IF p_resource_list_member_id IS NOT NULL THEN
84: BEGIN
85: SELECT typ.res_type_code
86: INTO l_res_type_code
87: FROM pa_res_types_b typ,
88: pa_resource_list_members rlm,
89: pa_res_formats_b fmt
90: WHERE rlm.resource_list_member_id = p_resource_list_member_id
91: AND rlm.res_format_id = fmt.res_format_id

Line 204: l_res_type_code pa_res_types_b.RES_TYPE_CODE%TYPE := null;

200: *************************************************************/
201: FUNCTION Get_res_type_code(p_res_format_id IN NUMBER)
202: RETURN VARCHAR2
203: IS
204: l_res_type_code pa_res_types_b.RES_TYPE_CODE%TYPE := null;
205: BEGIN
206: IF p_res_format_id IS NOT NULL THEN
207: SELECT b.res_type_code
208: INTO l_res_type_code

Line 209: FROM pa_res_formats_b a, pa_res_types_b b

205: BEGIN
206: IF p_res_format_id IS NOT NULL THEN
207: SELECT b.res_type_code
208: INTO l_res_type_code
209: FROM pa_res_formats_b a, pa_res_types_b b
210: WHERE a.RES_TYPE_ID = b.RES_TYPE_ID
211: AND a.RES_TYPE_ENABLED_FLAG = 'Y'
212: AND a.res_format_id = p_res_format_id;
213: Return l_res_type_code;

Line 2605: pa_res_types_b typ

2601: NULL
2602: FROM pa_res_member_id_temp b,
2603: pa_resource_list_members a,
2604: pa_res_formats_b fmt,
2605: pa_res_types_b typ
2606: WHERE a.resource_list_member_id = b.resource_list_member_id
2607: AND a.res_format_id = fmt.res_format_id
2608: AND fmt.res_type_id = typ.res_type_id(+);
2609:

Line 4560: Pa_Res_Types_B t

4556: f.Role_Disp_Chars,
4557: t.Res_Type_Code
4558: From
4559: Pa_Res_Formats_B f,
4560: Pa_Res_Types_B t
4561: Where
4562: f.Res_Type_Id = t.Res_Type_Id(+)
4563: And f.Res_Format_Id = P_Res_Format_Id;
4564:

Line 6406: Pa_Res_Types_B t

6402: f.supplier_enabled_flag,
6403: f.Res_Type_Id,
6404: t.Res_Type_Code
6405: FROM Pa_Res_Formats_B f,
6406: Pa_Res_Types_B t
6407: WHERE f.Res_Type_Id = t.Res_Type_Id(+)
6408: AND f.Res_Format_Id = p_res_format_id;
6409:
6410: l_resource_list_id NUMBER;

Line 7029: from pa_res_formats_b a,pa_res_types_b b, pa_plan_rl_formats c

7025: *****************************************/
7026: Cursor c_get_asgmt_res_formats
7027: IS
7028: select a.res_format_id
7029: from pa_res_formats_b a,pa_res_types_b b, pa_plan_rl_formats c
7030: where a.resource_class_id = 1
7031: and a.res_type_id = b.res_type_id (+)
7032: and c.res_format_id = a.res_format_id
7033: and c.resource_list_id = p_resource_list_id

Line 7045: from pa_res_formats_b a,pa_res_types_b b, pa_plan_rl_formats c

7041: *****************************************/
7042: Cursor c_get_req_res_formats
7043: IS
7044: select a.res_format_id
7045: from pa_res_formats_b a,pa_res_types_b b, pa_plan_rl_formats c
7046: where a.resource_class_id = 1
7047: and a.res_type_id = b.res_type_id (+)
7048: and c.res_format_id = a.res_format_id
7049: and c.resource_list_id = p_resource_list_id

Line 7584: Pa_Res_Types_B t

7580: f.Role_Enabled_Flag,
7581: f.Res_Type_Id,
7582: t.Res_Type_Code
7583: FROM Pa_Res_Formats_B f,
7584: Pa_Res_Types_B t
7585: WHERE f.Res_Type_Id = t.Res_Type_Id(+)
7586: AND f.Res_Format_Id = p_res_format_id;
7587:
7588: l_fmt_details get_fmt_details%RowType;