APPS.FTE_FREIGHT_PRICING_SPECIAL dependencies on FTE_PRC_PARAMETER_DEFAULTS

Line 112: FROM fte_prc_parameter_defaults fppd, fte_prc_parameters fpp

108: fppd.parameter_sub_type,
109: fppd.parameter_name,
110: fpp.value_from,
111: fppd.default_value_from
112: FROM fte_prc_parameter_defaults fppd, fte_prc_parameters fpp
113: WHERE fppd.parameter_id = fpp.parameter_id (+)
114: AND fpp.lane_id (+) = c_lane_id
115: AND fppd.lane_function = c_lane_function
116: AND fppd.parameter_type = 'RULE'

Line 122: FROM fte_prc_parameter_defaults fppd

118: ORDER BY fppd.parameter_sub_type, fppd.parameter_name;
119:
120: CURSOR c_patterns(c_lane_function IN VARCHAR2) IS
121: SELECT DISTINCT fppd.parameter_sub_type pattern_name
122: FROM fte_prc_parameter_defaults fppd
123: WHERE fppd.lane_function = c_lane_function
124: AND fppd.parameter_type = 'RULE'
125: ORDER BY 1;
126:

Line 274: FROM fte_prc_parameter_defaults fppd, fte_prc_parameters fpp

270: fppd.lane_function,fppd.parameter_sub_type, fppd.parameter_name,
271: nvl(fpp.value_from,fppd.default_value_from),
272: nvl(fpp.value_to,fppd.default_value_to),
273: fpp.uom_class, fpp.uom_code, fpp.currency_code
274: FROM fte_prc_parameter_defaults fppd, fte_prc_parameters fpp
275: WHERE fppd.parameter_id = fpp.parameter_id (+)
276: AND fpp.lane_id (+) = c_lane_id
277: AND fppd.parameter_type = 'PARAMETER'
278: ORDER BY fppd.parameter_type, fppd.parameter_sub_type, fppd.parameter_name;