DBA Data[Home] [Help]

APPS.FUN_RULE_OBJECTS_PKG dependencies on FUN_RULE_OBJECTS_VL

Line 623: FROM FUN_RULE_OBJECTS_VL

619: X_USE_INSTANCE_FLAG,
620: X_INSTANCE_LABEL,
621: X_PARENT_RULE_OBJECT_ID,
622: X_ORG_ID
623: FROM FUN_RULE_OBJECTS_VL
624: WHERE RULE_OBJECT_NAME = X_RULE_OBJECT_NAME
625: AND APPLICATION_ID = X_APPLICATION_ID
626: AND INSTANCE_LABEL IS NULL
627: AND ORG_ID IS NULL;

Line 669: FROM FUN_RULE_OBJECTS_VL

665: X_USE_INSTANCE_FLAG,
666: X_INSTANCE_LABEL,
667: X_PARENT_RULE_OBJECT_ID,
668: X_ORG_ID
669: FROM FUN_RULE_OBJECTS_VL
670: WHERE RULE_OBJECT_NAME = X_RULE_OBJECT_NAME
671: AND APPLICATION_ID = X_APPLICATION_ID
672: AND
673: ( (INSTANCE_LABEL IS NULL AND X_INSTANCE_LABEL IS NULL) OR

Line 757: FROM FUN_RULE_OBJECTS_VL

753: X_USE_INSTANCE_FLAG,
754: X_INSTANCE_LABEL,
755: X_PARENT_RULE_OBJECT_ID,
756: X_ORG_ID
757: FROM FUN_RULE_OBJECTS_VL
758: WHERE RULE_OBJECT_ID = X_RULE_OBJECT_ID;
759:
760: EXCEPTION
761: WHEN NO_DATA_FOUND THEN