APPS.CSD_PROCESS_PVT dependencies on CSD_REPAIR_TYPES_VL

Line 7201: FROM csd_repair_order_groups crog, csd_repair_types_vl crt

7197: CURSOR get_rep_group(p_incident_id IN NUMBER) IS
7198: SELECT crog.repair_group_id,
7199: crt.repair_type_ref,
7200: crog.group_txn_status
7201: FROM csd_repair_order_groups crog, csd_repair_types_vl crt
7202: WHERE crog.repair_type_id = crt.repair_type_id
7203: AND crog.incident_id = p_incident_id;
7204:
7205: CURSOR get_ro_order(p_repair_group_id IN NUMBER) IS

Line 9066: FROM csd_repairs dra, fnd_lookups fndl2, csd_repair_types_vl drtvl

9062: l_Inventory_Item_id,
9063: l_RO_Repair_Type_Ref,
9064: l_RO_Number,
9065: l_RO_Status_Meaning
9066: FROM csd_repairs dra, fnd_lookups fndl2, csd_repair_types_vl drtvl
9067: WHERE repair_line_id = p_Repair_line_id
9068: and dra.repair_type_id = drtvl.repair_type_id
9069: and dra.status = fndl2.lookup_code
9070: and fndl2.lookup_type = 'CSD_REPAIR_STATUS';