APPS.FUN_RULE_PUB dependencies on FUN_RULE_PARAM_VALUES

Line 75: FROM FUN_RULE_PARAM_VALUES FRMP,

71: AND FRC.CRITERIA_PARAM_ID = FRCP.CRITERIA_PARAM_ID
72: AND FRCP.PARAM_NAME = FLV.LOOKUP_CODE';
73:
74: g_sMultiCriteriaParamValueSql VARCHAR2(1000) := 'SELECT FRMP.PARAM_VALUE
75: FROM FUN_RULE_PARAM_VALUES FRMP,
76: FUN_RULE_CRITERIA FRC
77: WHERE FRC.RULE_DETAIL_ID = :1
78: AND FRC.CRITERIA_ID = FRMP.CRITERIA_ID
79: AND FRC.CRITERIA_ID = :2 ';

Line 1374: l_param_value FUN_RULE_PARAM_VALUES.PARAM_VALUE%TYPE;

1370:
1371: params_cursor INTEGER;
1372: params_rows_processed INTEGER;
1373:
1374: l_param_value FUN_RULE_PARAM_VALUES.PARAM_VALUE%TYPE;
1375: l_counter NUMBER := 1;
1376:
1377: BEGIN
1378: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then