DBA Data[Home] [Help]

APPS.FUN_RULE_OBJECTS_PUB dependencies on FUN_RULE_CRIT_PARAMS_TL

Line 1162: DELETE FROM FUN_RULE_CRIT_PARAMS_TL FRCP

1158: WHERE FROB.RULE_OBJECT_ID = FRD.RULE_OBJECT_ID
1159: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1160:
1161:
1162: DELETE FROM FUN_RULE_CRIT_PARAMS_TL FRCP
1163: WHERE CRITERIA_PARAM_ID IN (SELECT CRITERIA_PARAM_ID
1164: FROM FUN_RULE_OBJECTS_B FROB, FUN_RULE_CRIT_PARAMS_B FRCPB
1165: WHERE FROB.RULE_OBJECT_ID = FRCPB.RULE_OBJECT_ID
1166: AND RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);

Line 1367: DELETE FROM FUN_RULE_CRIT_PARAMS_TL FRCP

1363: ( ORG_ID IS NOT NULL AND p_org_id IS NOT NULL AND ORG_ID = p_org_id))
1364: AND PARENT_RULE_OBJECT_ID IS NOT NULL);
1365:
1366:
1367: DELETE FROM FUN_RULE_CRIT_PARAMS_TL FRCP
1368: WHERE CRITERIA_PARAM_ID IN (SELECT CRITERIA_PARAM_ID
1369: FROM FUN_RULE_OBJECTS_B FROB, FUN_RULE_CRIT_PARAMS_B FRCPB
1370: WHERE FROB.RULE_OBJECT_ID = FRCPB.RULE_OBJECT_ID
1371: AND RULE_OBJECT_NAME = P_RULE_OBJECT_NAME