APPS.PA_AP_INTEGRATION dependencies on PA_RESOURCES

Line 164: l_resource_id pa_resources.resource_id%type;

160: l_track_as_labor_flag varchar2(10);
161: l_err_code Varchar2(200);
162: l_err_stage Varchar2(200);
163: l_err_stack Varchar2(2000);
164: l_resource_id pa_resources.resource_id%type;
165:
166: Begin
167: x_stage := 'Start For Summarization';
168: for rec1 in c_resource_list loop

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

172:
173: Begin
174: x_stage:='See whether New vendor exists as resource in PA tables';
175:
176: Select nvl(count(a.name),0) into l_new_vendor_exists_resource from pa_resource_types b, pa_resources a
177: where a.RESOURCE_TYPE_ID=b.RESOURCE_TYPE_ID and b.RESOURCE_TYPE_CODE='VENDOR'
178: And a.name = l_new_vendor_name;
179:
180: Exception When no_data_found then l_new_vendor_exists_resource := 0;