APPS.PA_AP_INTEGRATION dependencies on PA_RESOURCE_TYPES

Line 240: Select nvl(count(a.name),0) into l_new_vendor_exists_resource from pa_resource_types b, pa_resources a

236:
237: Begin
238: x_stage:='See whether New vendor exists as resource in PA tables';
239:
240: Select nvl(count(a.name),0) into l_new_vendor_exists_resource from pa_resource_types b, pa_resources a
241: where a.RESOURCE_TYPE_ID=b.RESOURCE_TYPE_ID and b.RESOURCE_TYPE_CODE='VENDOR'
242: And a.name = l_new_vendor_name;
243:
244: Exception When no_data_found then l_new_vendor_exists_resource := 0;