APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_RES_FORMATS_B

Line 93: pa_res_formats_b fmt

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
96: AND fmt.res_type_enabled_flag = 'Y'
97: AND fmt.res_type_id = typ.res_type_id;

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 2645: pa_res_formats_b fmt,

2641: NULL ,
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(+);

Line 4600: Pa_Res_Formats_B f,

4596: f.Supplier_Disp_Chars,
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;

Line 5699: Pa_Res_Formats_B

5695: Supplier_Enabled_Flag,
5696: Role_Enabled_flag,
5697: Resource_Class_Flag
5698: From
5699: Pa_Res_Formats_B
5700: Where
5701: Res_Format_Id = P_Res_Format_Id;
5702:
5703: CURSOR get_job_group_id(p_res_list_id in NUMBER) is

Line 6563: FROM Pa_Res_Formats_B f,

6559: f.incurred_by_enabled_flag,
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:

Line 7030: FROM pa_res_formats_b

7026: *****************************************************/
7027: BEGIN
7028: SELECT resource_class_id
7029: INTO l_resource_class_id
7030: FROM pa_res_formats_b
7031: WHERE res_format_id = p_res_format_id;
7032: EXCEPTION
7033: WHEN OTHERS THEN
7034: l_resource_list_member_id := NULL;

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 7741: FROM Pa_Res_Formats_B f,

7737: f.Fin_Cat_Enabled_Flag,
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: