DBA Data[Home] [Help]

APPS.FUN_RULE_OBJECTS_PUB dependencies on FUN_RULE_TEST_MVAL_RES

Line 1197: DELETE FROM FUN_RULE_TEST_MVAL_RES FRTMR

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);
1196:
1197: DELETE FROM FUN_RULE_TEST_MVAL_RES FRTMR
1198: WHERE TEST_ID IN (SELECT TEST_ID
1199: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1200: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1201: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);

Line 1444: DELETE FROM FUN_RULE_TEST_MVAL_RES FRTMR

1440: ( ORG_ID IS NOT NULL AND p_org_id IS NOT NULL AND ORG_ID = p_org_id))
1441: AND PARENT_RULE_OBJECT_ID IS NOT NULL);
1442:
1443:
1444: DELETE FROM FUN_RULE_TEST_MVAL_RES FRTMR
1445: WHERE TEST_ID IN (SELECT TEST_ID
1446: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1447: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1448: AND RULE_OBJECT_NAME = P_RULE_OBJECT_NAME