APPS.EDW_SOURCE_INSTANCES_PKG dependencies on EDW_SOURCE_INSTANCES_VL

Line 407: FROM EDW_SOURCE_INSTANCES_VL

403: ) IS
404: dummy NUMBER;
405: BEGIN
406: SELECT COUNT(1) INTO dummy
407: FROM EDW_SOURCE_INSTANCES_VL
408: WHERE INSTANCE_CODE = X_INSTANCE_CODE
409: AND ((X_ROWID IS NULL) OR (ROW_ID <> X_ROWID));
410:
411: IF (dummy >= 1) THEN

Line 444: FROM EDW_SOURCE_INSTANCES_VL

440: dummy NUMBER;
441: BEGIN
442: /* will fail cos the rowid is for edw_source_instances and NOT tl */
443: SELECT count(*) INTO dummy
444: FROM EDW_SOURCE_INSTANCES_VL
445: WHERE NAME = X_INSTANCE_NAME
446: AND ((X_ROWID IS NULL) OR (ROW_ID <> X_ROWID));
447:
448:

Line 465: FROM EDW_SOURCE_INSTANCES_VL

461: ) IS
462: dummy NUMBER;
463: BEGIN
464: SELECT COUNT(1) INTO dummy
465: FROM EDW_SOURCE_INSTANCES_VL
466: WHERE WAREHOUSE_TO_INSTANCE_LINK = X_DBLINK
467: AND ((X_ROWID IS NULL) OR (ROW_ID <> X_ROWID));
468:
469: IF (dummy >= 1) THEN