APPS.PA_PLAN_RES_LIST_PUB dependencies on PA_RES_FORMATS_B

Line 1717: FROM pa_res_formats_b

1713: BEGIN
1714:
1715: SELECT 'Y'
1716: INTO l_exists
1717: FROM pa_res_formats_b
1718: WHERE res_format_id = L_Plan_RL_Format_Tbl(i).P_Res_Format_Id;
1719:
1720: EXCEPTION
1721: WHEN NO_DATA_FOUND THEN

Line 1893: FROM pa_res_formats_b

1889: BEGIN
1890: -- derive resource_class_flag
1891: SELECT resource_class_flag
1892: INTO l_res_class_flag
1893: FROM pa_res_formats_b
1894: WHERE res_format_id = L_planning_resource_in_tbl(i).p_res_format_id;
1895: EXCEPTION
1896: WHEN NO_DATA_FOUND THEN
1897: Pa_Utils.Add_Message(

Line 2531: From pa_res_formats_b

2527: -- If 'Y' Then format is valid.
2528:
2529: Select 'Y'
2530: Into l_format_exists
2531: From pa_res_formats_b
2532: Where res_format_id=L_Plan_RL_Format_Tbl(i).P_Res_Format_Id;
2533:
2534: EXCEPTION
2535: WHEN Others THEN

Line 2804: FROM pa_res_formats_b f, pa_res_types_b t

2800: l_organization,
2801: l_supplier,
2802: l_role,
2803: l_incurred
2804: FROM pa_res_formats_b f, pa_res_types_b t
2805: WHERE f.res_format_id = L_Planning_resource_in_tbl(i).P_Res_Format_Id
2806: AND f.RES_TYPE_ID = t.res_type_id(+);
2807:
2808: EXCEPTION WHEN OTHERS THEN

Line 3020: From pa_res_formats_b

3016:
3017: -- derive resource_class_flag
3018: Select resource_class_flag
3019: Into l_res_class_flag
3020: From pa_res_formats_b
3021: Where res_format_id = L_planning_resource_in_tbl(i).p_res_format_id;
3022:
3023: Pa_Planning_Resource_Pvt.Create_Planning_Resource(
3024: p_resource_list_id => p_resource_list_id,