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 1382: l_param_value FUN_RULE_PARAM_VALUES.PARAM_VALUE%TYPE;

1378:
1379: params_cursor INTEGER;
1380: params_rows_processed INTEGER;
1381:
1382: l_param_value FUN_RULE_PARAM_VALUES.PARAM_VALUE%TYPE;
1383: l_counter NUMBER := 1;
1384:
1385: BEGIN
1386: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then