APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_RES_TYPES_B

Line 91: FROM pa_res_types_b typ,

87: IF p_resource_list_member_id IS NOT NULL THEN
88: BEGIN
89: SELECT typ.res_type_code
90: INTO l_res_type_code
91: FROM pa_res_types_b typ,
92: pa_resource_list_members rlm,
93: pa_res_formats_b fmt
94: WHERE rlm.resource_list_member_id = p_resource_list_member_id
95: AND rlm.res_format_id = fmt.res_format_id

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

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

Line 213: FROM pa_res_formats_b a, pa_res_types_b b

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

Line 2646: pa_res_types_b typ

2642: NULL
2643: FROM pa_res_member_id_temp b,
2644: pa_resource_list_members a,
2645: pa_res_formats_b fmt,
2646: pa_res_types_b typ
2647: WHERE a.resource_list_member_id = b.resource_list_member_id
2648: AND a.res_format_id = fmt.res_format_id
2649: AND fmt.res_type_id = typ.res_type_id(+);
2650:

Line 4601: Pa_Res_Types_B t

4597: f.Role_Disp_Chars,
4598: t.Res_Type_Code
4599: From
4600: Pa_Res_Formats_B f,
4601: Pa_Res_Types_B t
4602: Where
4603: f.Res_Type_Id = t.Res_Type_Id(+)
4604: And f.Res_Format_Id = P_Res_Format_Id;
4605:

Line 6564: Pa_Res_Types_B t

6560: f.supplier_enabled_flag,
6561: f.Res_Type_Id,
6562: t.Res_Type_Code
6563: FROM Pa_Res_Formats_B f,
6564: Pa_Res_Types_B t
6565: WHERE f.Res_Type_Id = t.Res_Type_Id(+)
6566: AND f.Res_Format_Id = p_res_format_id;
6567:
6568: l_resource_list_id NUMBER;

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

7183: *****************************************/
7184: Cursor c_get_asgmt_res_formats
7185: IS
7186: select a.res_format_id
7187: from pa_res_formats_b a,pa_res_types_b b, pa_plan_rl_formats c
7188: where a.resource_class_id = 1
7189: and a.res_type_id = b.res_type_id (+)
7190: and c.res_format_id = a.res_format_id
7191: and c.resource_list_id = p_resource_list_id

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

7199: *****************************************/
7200: Cursor c_get_req_res_formats
7201: IS
7202: select a.res_format_id
7203: from pa_res_formats_b a,pa_res_types_b b, pa_plan_rl_formats c
7204: where a.resource_class_id = 1
7205: and a.res_type_id = b.res_type_id (+)
7206: and c.res_format_id = a.res_format_id
7207: and c.resource_list_id = p_resource_list_id

Line 7742: Pa_Res_Types_B t

7738: f.Role_Enabled_Flag,
7739: f.Res_Type_Id,
7740: t.Res_Type_Code
7741: FROM Pa_Res_Formats_B f,
7742: Pa_Res_Types_B t
7743: WHERE f.Res_Type_Id = t.Res_Type_Id(+)
7744: AND f.Res_Format_Id = p_res_format_id;
7745:
7746: l_fmt_details get_fmt_details%RowType;