APPS.PA_RESOURCE_MAPPING dependencies on PA_RESOURCE_CLASSES_B

Line 776: pa_resource_classes_b cls

772: cls.RESOURCE_CLASS_ID,
773: cls.RESOURCE_CLASS_CODE
774: FROM
775: pa_res_list_map_tmp3 tmp3,
776: pa_resource_classes_b cls
777: WHERE
778: RESOURCE_LIST_MEMBER_ID IS NULL AND
779: nvl(tmp3.resource_class_id, l_resource_class_id) = cls.resource_class_id;
780:

Line 1050: pa_resource_classes_b;

1046: IS
1047: SELECT
1048: resource_class_id
1049: FROM
1050: pa_resource_classes_b;
1051:
1052: l_res_list_formats SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1053: l_res_class_formats PA_RESOURCE_PREC_PUB.plan_res_formats;
1054: l_format NUMBER;

Line 1142: PA_RESOURCE_CLASSES_B classes,

1138: FROM PA_EXPENDITURE_TYPES typ
1139: WHERE typ.EXPENDITURE_TYPE = tmp1.EXPENDITURE_TYPE ) )
1140: ,tmp1.ITEM_CATEGORY_ID = nvl(tmp1.ITEM_CATEGORY_ID, (SELECT cat.CATEGORY_ID
1141: FROM
1142: PA_RESOURCE_CLASSES_B classes,
1143: PA_PLAN_RES_DEFAULTS cls,
1144: MTL_ITEM_CATEGORIES cat
1145: WHERE
1146: classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS' and

Line 1161: PA_RESOURCE_CLASSES_B classes,

1157: WHERE tmp1.EXPENDITURE_CATEGORY IS NULL;
1158: UPDATE pa_res_list_map_tmp1 tmp1
1159: SET tmp1.ITEM_CATEGORY_ID = (SELECT cat.CATEGORY_ID
1160: FROM
1161: PA_RESOURCE_CLASSES_B classes,
1162: PA_PLAN_RES_DEFAULTS cls,
1163: MTL_ITEM_CATEGORIES cat
1164: WHERE
1165: classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS' and