APPS.FUN_RULE_CRIT_PARAMS_PUB dependencies on FUN_RULE_CRIT_PARAMS_B

Line 142: FROM FUN_RULE_CRIT_PARAMS_B B, FUN_RULE_CRIT_PARAMS_TL TL

138: tip_text,
139: B.data_type,
140: B.flex_value_set_id,
141: B.created_by_module
142: FROM FUN_RULE_CRIT_PARAMS_B B, FUN_RULE_CRIT_PARAMS_TL TL
143: WHERE B.RULE_OBJECT_ID = p_from_rule_object_id
144: AND B.CRITERIA_PARAM_ID = TL.CRITERIA_PARAM_ID
145: AND TL.LANGUAGE='US';
146:

Line 272: FROM FUN_RULE_CRIT_PARAMS_B

268: SELECT OBJECT_VERSION_NUMBER,
269: ROWID
270: INTO l_object_version_number,
271: l_rowid
272: FROM FUN_RULE_CRIT_PARAMS_B
273: WHERE PARAM_NAME = p_rule_crit_param_rec.param_name
274: AND RULE_OBJECT_ID = p_rule_crit_param_rec.rule_object_id
275: FOR UPDATE OF PARAM_NAME NOWAIT;
276:

Line 721: FROM fun_rule_crit_params_b cp

717: x_return_status := FND_API.G_RET_STS_SUCCESS;
718:
719: SELECT cp.criteria_param_id
720: INTO cpid
721: FROM fun_rule_crit_params_b cp
722: where cp.rule_object_id = p_rule_object_id
723: and cp.param_name = p_param_name;
724:
725: x_rule_crit_param_rec.criteria_param_id := cpid;