DBA Data[Home] [Help]

APPS.FUN_RULE_OBJECTS_PUB dependencies on FUN_RULE_TEST_RESULTS

Line 1191: DELETE FROM FUN_RULE_TEST_RESULTS FRTR

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);
1190:
1191: DELETE FROM FUN_RULE_TEST_RESULTS FRTR
1192: WHERE TEST_ID IN (SELECT TEST_ID
1193: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1194: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1195: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);

Line 1431: DELETE FROM FUN_RULE_TEST_RESULTS FRTR

1427: ( ORG_ID IS NOT NULL AND p_org_id IS NOT NULL AND ORG_ID = p_org_id))
1428: AND PARENT_RULE_OBJECT_ID IS NOT NULL);
1429:
1430:
1431: DELETE FROM FUN_RULE_TEST_RESULTS FRTR
1432: WHERE TEST_ID IN (SELECT TEST_ID
1433: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1434: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1435: AND RULE_OBJECT_NAME = P_RULE_OBJECT_NAME