DBA Data[Home] [Help]

APPS.FUN_RULE_OBJECTS_PUB dependencies on FUN_RULE_TEST_MULTIRULE

Line 1185: DELETE FROM FUN_RULE_TEST_MULTIRULE FRTP

1181: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1182:
1183: --TEST Related tables deletion starts from here
1184:
1185: DELETE FROM FUN_RULE_TEST_MULTIRULE FRTP
1186: WHERE TEST_ID IN (SELECT TEST_ID
1187: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1188: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1189: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);

Line 1418: DELETE FROM FUN_RULE_TEST_MULTIRULE FRTP

1414:
1415:
1416: --TEST Related tables deletion starts from here
1417:
1418: DELETE FROM FUN_RULE_TEST_MULTIRULE FRTP
1419: WHERE TEST_ID IN (SELECT TEST_ID
1420: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1421: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1422: AND RULE_OBJECT_NAME = P_RULE_OBJECT_NAME