APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_RES_FORMATS_B

Line 89: pa_res_formats_b fmt

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

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

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

Line 4559: Pa_Res_Formats_B f,

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

Line 5614: Pa_Res_Formats_B

5610: Supplier_Enabled_Flag,
5611: Role_Enabled_flag,
5612: Resource_Class_Flag
5613: From
5614: Pa_Res_Formats_B
5615: Where
5616: Res_Format_Id = P_Res_Format_Id;
5617:
5618: CURSOR get_job_group_id(p_res_list_id in NUMBER) is

Line 6405: FROM Pa_Res_Formats_B f,

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

Line 6872: FROM pa_res_formats_b

6868: *****************************************************/
6869: BEGIN
6870: SELECT resource_class_id
6871: INTO l_resource_class_id
6872: FROM pa_res_formats_b
6873: WHERE res_format_id = p_res_format_id;
6874: EXCEPTION
6875: WHEN OTHERS THEN
6876: l_resource_list_member_id := NULL;

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

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