APPS.FTE_TL_COST_ALLOCATION dependencies on WSH_FREIGHT_COST_TYPES

Line 1084: FROM WSH_FREIGHT_COST_TYPES f

1080: i NUMBER;
1081:
1082: CURSOR get_fc_price_codes(c_name IN VARCHAR2) IS
1083: SELECT f.freight_cost_type_id
1084: FROM WSH_FREIGHT_COST_TYPES f
1085: WHERE f.freight_cost_type_code='FTEPRICE' AND f.name=c_name;
1086:
1087: CURSOR get_fc_charge_codes(c_name IN VARCHAR2) IS
1088: SELECT f.freight_cost_type_id

Line 1089: FROM WSH_FREIGHT_COST_TYPES f

1085: WHERE f.freight_cost_type_code='FTEPRICE' AND f.name=c_name;
1086:
1087: CURSOR get_fc_charge_codes(c_name IN VARCHAR2) IS
1088: SELECT f.freight_cost_type_id
1089: FROM WSH_FREIGHT_COST_TYPES f
1090: WHERE f.freight_cost_type_code='FTECHARGE' AND f.name=c_name;
1091:
1092: CURSOR get_fc_summary_codes(c_name IN VARCHAR2) IS
1093: SELECT f.freight_cost_type_id

Line 1094: FROM WSH_FREIGHT_COST_TYPES f

1090: WHERE f.freight_cost_type_code='FTECHARGE' AND f.name=c_name;
1091:
1092: CURSOR get_fc_summary_codes(c_name IN VARCHAR2) IS
1093: SELECT f.freight_cost_type_id
1094: FROM WSH_FREIGHT_COST_TYPES f
1095: WHERE f.freight_cost_type_code='FTESUMMARY'AND f.name=c_name;
1096:
1097: CURSOR get_fc_discount_codes(c_name IN VARCHAR2) IS
1098: SELECT f.freight_cost_type_id

Line 1099: FROM WSH_FREIGHT_COST_TYPES f

1095: WHERE f.freight_cost_type_code='FTESUMMARY'AND f.name=c_name;
1096:
1097: CURSOR get_fc_discount_codes(c_name IN VARCHAR2) IS
1098: SELECT f.freight_cost_type_id
1099: FROM WSH_FREIGHT_COST_TYPES f
1100: WHERE f.freight_cost_type_code='FTEDISCOUNT'AND f.name=c_name;
1101:
1102:
1103: l_return_status VARCHAR2(1);