DBA Data[Home] [Help]

APPS.PA_LOOKUPS_PKG dependencies on PA_BUDGET_VERSIONS

Line 387: from pa_budget_versions bv

383: into x_dummy
384: from sys.dual
385: where not exists
386: (select 1
387: from pa_budget_versions bv
388: where bv.change_reason_code = x_lookup_code);
389:
390: EXCEPTION
391: WHEN NO_DATA_FOUND then

Line 420: -- PM Product code Pa budget versions

416: WHEN OTHERS then
417: x_return_status := SQLCODE;
418: return;
419: End;
420: -- PM Product code Pa budget versions
421: Begin
422: select 1 into x_dummy
423: from sys.dual
424: where not exists

Line 425: (select 1 from pa_budget_versions where pm_product_code

421: Begin
422: select 1 into x_dummy
423: from sys.dual
424: where not exists
425: (select 1 from pa_budget_versions where pm_product_code
426: = x_lookup_code );
427: EXCEPTION
428: WHEN NO_DATA_FOUND then
429: x_return_status := 1;