DBA Data[Home] [Help]

APPS.PA_PLAN_RES_LIST_PUB dependencies on PA_RESOURCE_CLASSES_B

Line 2800: FROM pa_resource_classes_b

2796:
2797: --For bug 3810000
2798: IF L_Planning_resource_in_tbl(i).P_Resource_Class_Code is not NULL Then
2799: select count(*) INTO l_validate_resource_code
2800: FROM pa_resource_classes_b
2801: WHERE resource_class_code=L_Planning_resource_in_tbl(i).P_Resource_Class_Code;
2802: IF l_validate_resource_code <> 0 Then
2803: Null;
2804: Else

Line 2811: FROM pa_resource_classes_b

2807: END IF;
2808:
2809: IF L_Planning_resource_in_tbl(i).P_Resource_Class_id is not NULL Then
2810: select count(*) INTO l_validate_resource_id
2811: FROM pa_resource_classes_b
2812: WHERE resource_class_id=L_Planning_resource_in_tbl(i).P_Resource_Class_id;
2813: IF l_validate_resource_id <> 0 Then
2814: Null;
2815: Else