APPS.PA_AP_INTEGRATION dependencies on PA_RESOURCES

Line 228: l_resource_id pa_resources.resource_id%type;

224: l_track_as_labor_flag varchar2(10);
225: l_err_code Varchar2(200);
226: l_err_stage Varchar2(200);
227: l_err_stack Varchar2(2000);
228: l_resource_id pa_resources.resource_id%type;
229:
230: Begin
231: x_stage := 'Start For Summarization';
232: for rec1 in c_resource_list loop

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;