DBA Data[Home] [Help]

APPS.INVPVDR6 dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 383: /* Fix for bug 5844510-Use org_organization_definitions view

379: stmt := 38;
380: -- validate foreign keys
381: if cr.SOURCE_ORGANIZATION_ID is not null then
382: begin
383: /* Fix for bug 5844510-Use org_organization_definitions view
384: instead of mtl_parameters to validate the source org, since
385: an organization's disable date can be obtained from ood view.
386: select 'x' into temp
387: from MTL_PARAMETERS

Line 391: from org_organization_definitions

387: from MTL_PARAMETERS
388: where ORGANIZATION_ID = cr.SOURCE_ORGANIZATION_ID;
389: */
390: select 'x' into temp
391: from org_organization_definitions
392: where ORGANIZATION_ID = cr.SOURCE_ORGANIZATION_ID
393: and nvl(disable_date,sysdate+1) > sysdate;
394: exception
395: when NO_DATA_FOUND then