DBA Data[Home] [Help]

APPS.FUN_RULE_OBJECTS_PUB dependencies on FUN_RULE_TEST_PARAMS

Line 1203: DELETE FROM FUN_RULE_TEST_PARAMS FRTP

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);
1202:
1203: DELETE FROM FUN_RULE_TEST_PARAMS FRTP
1204: WHERE TEST_ID IN (SELECT TEST_ID
1205: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1206: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1207: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);

Line 1457: DELETE FROM FUN_RULE_TEST_PARAMS FRTP

1453: ( ORG_ID IS NOT NULL AND p_org_id IS NOT NULL AND ORG_ID = p_org_id))
1454: AND PARENT_RULE_OBJECT_ID IS NOT NULL);
1455:
1456:
1457: DELETE FROM FUN_RULE_TEST_PARAMS FRTP
1458: WHERE TEST_ID IN (SELECT TEST_ID
1459: FROM FUN_RULE_TESTS FRT , FUN_RULE_OBJECTS_B FROB
1460: WHERE FROB.RULE_OBJECT_ID = FRT.RULE_OBJECT_ID
1461: AND RULE_OBJECT_NAME = P_RULE_OBJECT_NAME