APPS.CSD_RETURNS_UTIL dependencies on CSD_REPAIR_TYPES_B

Line 1845: FROM csd_repair_types_b

1841:
1842: -- get the autoprocess RMA flag.
1843: SELECT NVL(auto_process_rma,'N'),repair_mode
1844: INTO l_repln_rec.auto_process_rma,l_repln_rec.repair_mode
1845: FROM csd_repair_types_b
1846: WHERE repair_type_id = l_repln_rec.repair_type_id;
1847:
1848: -- assign the flexfield attributes.
1849: l_repln_rec.return_attribute_category :=p_return_attribute_category(i);

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;