APPS.CSD_RETURNS_UTIL dependencies on CSD_REPAIR_TYPES_SAR_VL

Line 553: FROM csd_repair_types_sar_vl

549: THEN
550: -- get the txn billing type id
551: SELECT txn_billing_type_id
552: INTO l_txn_billing_type_id
553: FROM csd_repair_types_sar_vl
554: WHERE repair_type_id = p_repair_type_ids(i)
555: AND billing_type = 'M';
556: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
557: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_charge_line_util.get_discountedprice to get warranty discounts:');

Line 2046: FROM csd_repair_types_sar_vl service,csd_repair_types_b types

2042: THEN
2043: SELECT service.txn_billing_type_id,service.transaction_type_id,types.business_process_id
2044: INTO G_ESTIMATE_CONSTANTS_CACHE(p_item_ids(i)).txn_billing_type_id,
2045: G_ESTIMATE_CONSTANTS_CACHE(p_item_ids(i)).transaction_type_id,G_ESTIMATE_CONSTANTS_CACHE(p_item_ids(i)).business_process_id
2046: FROM csd_repair_types_sar_vl service,csd_repair_types_b types
2047: WHERE service.repair_type_id = p_repair_type_ids(i)
2048: AND service.repair_type_id = types.repair_type_id
2049: AND service.billing_type = 'M';
2050: END IF;