DBA Data[Home] [Help]

APPS.FUN_RULE_OBJECTS_PUB dependencies on FUN_RULE_PARAM_VALUES

Line 1155: DELETE FROM FUN_RULE_PARAM_VALUES FRPV

1151:
1152: --Instead of calling the delete apis of the tables for each record, from performance point of view
1153: --its better to issue direct delete statement.
1154:
1155: DELETE FROM FUN_RULE_PARAM_VALUES FRPV
1156: WHERE RULE_DETAIL_ID IN (SELECT RULE_DETAIL_ID
1157: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_B FROB
1158: WHERE FROB.RULE_OBJECT_ID = FRD.RULE_OBJECT_ID
1159: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);

Line 1354: DELETE FROM FUN_RULE_PARAM_VALUES FRPV

1350:
1351: --Instead of calling the delete apis of the tables for each record, from performance point of view
1352: --its better to issue direct delete statement.
1353:
1354: DELETE FROM FUN_RULE_PARAM_VALUES FRPV
1355: WHERE RULE_DETAIL_ID IN (SELECT RULE_DETAIL_ID
1356: FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_B FROB
1357: WHERE FROB.RULE_OBJECT_ID = FRD.RULE_OBJECT_ID
1358: AND FROB.RULE_OBJECT_NAME = P_RULE_OBJECT_NAME