APPS.PA_PLAN_RES_LIST_PUB dependencies on PA_RES_FORMATS_B

Line 1732: FROM pa_res_formats_b

1728: BEGIN
1729:
1730: SELECT 'Y'
1731: INTO l_exists
1732: FROM pa_res_formats_b
1733: WHERE res_format_id = L_Plan_RL_Format_Tbl(i).P_Res_Format_Id;
1734:
1735: EXCEPTION
1736: WHEN NO_DATA_FOUND THEN

Line 1908: FROM pa_res_formats_b

1904: BEGIN
1905: -- derive resource_class_flag
1906: SELECT resource_class_flag
1907: INTO l_res_class_flag
1908: FROM pa_res_formats_b
1909: WHERE res_format_id = L_planning_resource_in_tbl(i).p_res_format_id;
1910: EXCEPTION
1911: WHEN NO_DATA_FOUND THEN
1912: Pa_Utils.Add_Message(

Line 2548: From pa_res_formats_b

2544: -- If 'Y' Then format is valid.
2545:
2546: Select 'Y'
2547: Into l_format_exists
2548: From pa_res_formats_b
2549: Where res_format_id=L_Plan_RL_Format_Tbl(i).P_Res_Format_Id;
2550:
2551: EXCEPTION
2552: WHEN Others THEN

Line 2836: FROM pa_res_formats_b f, pa_res_types_b t

2832: l_organization,
2833: l_supplier,
2834: l_role,
2835: l_incurred
2836: FROM pa_res_formats_b f, pa_res_types_b t
2837: WHERE f.res_format_id = L_Planning_resource_in_tbl(i).P_Res_Format_Id
2838: AND f.RES_TYPE_ID = t.res_type_id(+);
2839:
2840: EXCEPTION WHEN OTHERS THEN

Line 3052: From pa_res_formats_b

3048:
3049: -- derive resource_class_flag
3050: Select resource_class_flag
3051: Into l_res_class_flag
3052: From pa_res_formats_b
3053: Where res_format_id = L_planning_resource_in_tbl(i).p_res_format_id;
3054:
3055: Pa_Planning_Resource_Pvt.Create_Planning_Resource(
3056: p_resource_list_id => p_resource_list_id,