DBA Data[Home] [Help]

APPS.FUN_RULE_OBJECTS_PUB dependencies on FUN_RULE_CRITERIA

Line 1177: DELETE FROM FUN_RULE_CRITERIA FRC

1173: DELETE FROM FUN_RULE_DETAILS FRD
1174: WHERE RULE_OBJECT_ID IN (SELECT RULE_OBJECT_ID
1175: FROM FUN_RULE_OBJECTS_B WHERE
1176: RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1177: DELETE FROM FUN_RULE_CRITERIA FRC
1178: WHERE RULE_DETAIL_ID IN (SELECT RULE_DETAIL_ID
1179: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_B FROB
1180: WHERE FROB.RULE_OBJECT_ID = FRD.RULE_OBJECT_ID
1181: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);

Line 1403: DELETE FROM FUN_RULE_CRITERIA FRC

1399: AND ( (ORG_ID IS NULL AND p_org_id IS NULL) OR
1400: ( ORG_ID IS NOT NULL AND p_org_id IS NOT NULL AND ORG_ID = p_org_id))
1401: AND PARENT_RULE_OBJECT_ID IS NOT NULL);
1402:
1403: DELETE FROM FUN_RULE_CRITERIA FRC
1404: WHERE RULE_DETAIL_ID IN (SELECT RULE_DETAIL_ID
1405: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_B FROB
1406: WHERE FROB.RULE_OBJECT_ID = FRD.RULE_OBJECT_ID
1407: AND RULE_OBJECT_NAME = P_RULE_OBJECT_NAME