DBA Data[Home] [Help]

APPS.PA_PLAN_RES_LIST_PUB dependencies on PA_RESOURCE_CLASSES_B

Line 2768: FROM pa_resource_classes_b

2764:
2765: --For bug 3810000
2766: IF L_Planning_resource_in_tbl(i).P_Resource_Class_Code is not NULL Then
2767: select count(*) INTO l_validate_resource_code
2768: FROM pa_resource_classes_b
2769: WHERE resource_class_code=L_Planning_resource_in_tbl(i).P_Resource_Class_Code;
2770: IF l_validate_resource_code <> 0 Then
2771: Null;
2772: Else

Line 2779: FROM pa_resource_classes_b

2775: END IF;
2776:
2777: IF L_Planning_resource_in_tbl(i).P_Resource_Class_id is not NULL Then
2778: select count(*) INTO l_validate_resource_id
2779: FROM pa_resource_classes_b
2780: WHERE resource_class_id=L_Planning_resource_in_tbl(i).P_Resource_Class_id;
2781: IF l_validate_resource_id <> 0 Then
2782: Null;
2783: Else